Recent content by jalpino

You can loop through the form collection to insert the name value pairs, for example: <cfloop collection="#form#" item="fieldName"> <cfquery name="qryInsert" ....... > INSERT INTO TAble ( fieldName, fieldValue) VALUES ('#fieldName#','#form[fieldName]#')...

If you need to 'lock' a set of sql commands in a single transaction, use <cftransaction>, it will provide the isolation levels that you need. However if the transaction spans multiple requests, insert\update a timestamp with the db entry and also persist that stamp in the users session. The next...

Actually, requests coming in without a referer will most likely be because they navigated to your site directly (typing your site directly into the address bar). JAlpino

Hi Natalie, Are you using log4j in your Java objects? If so, I'll bet that it is a 'much' newer version than the one mx7 uses, and since your classes are loaded later in the chain on the class loader, your code will attempt to use the old library CF uses. Attempting to load your classes before...

Are you on shared hosting? If so you might not be able to specify your own file for 404's. However if you aren't, setting up a custom 404 will be web server specific (ie. IIS vs. Apache). What web server are you using?

Hi Boatguy, The reason for your error this time is because of the commas in your string (on line 40). Replace the comma with that variable called 'newDelim' or wrap the commas in double quotes like so: <cfset newFileContents = newFileContents & "," & email & "," & Date & "," & FirstName & ","...

hi boatguy, I'm guessing you got the jist of what I was trying to show you, I hope it works out for you and if it doesn't, keep posting back to the forum so we can help solve it. As far as the error exception goes, GUJUm0deL picked off the code that was throwing the error, there should not be...

Does the <cfheader> tag not work in your version of FB? What version are you using? If you don't mind the 302, use <cflocation>. If you have to have the 301 and it doesn't work for some reason within the context the framework, call it from Application.[cfm|cfc] JAlpino

Removing duplicate records in the CSV file, isn't all that difficult. Provided that each line in the file represents a row, and each row has the same number of columns (text delimited by the pipe), then you can use the <cfhttp> tag to automagicly convert the csv into a query. Once the contents...

Stripping out all unneccesary whitespace and line breaks reduces the file size of your pages, which helps make them load faster and will save you money as bandwidth is reduced on page loads. For sites like MSN and Google, every little bit helps. JAlpino

Or you can use the listQualify() function, like so: SELECT * FROM dev WHERE dev_volgnr IN (#listQualify(FORMvalue)#) Hope this helps, JAlpino

hi NetworkGhost, You are close, but there is no need for the extra pound signs(#) inside of your <cfif> statement. Good job with using the isDefined() function. If the variable doesn't exist, CF will short circuit your condition at that statement and save some processing time by ignoring the...

hi harrymossman, What do you mean by "How do I tell them to use the 6.1 server"? If you ment that you wanted to know to get dreamweaver and homesite to show the new functions\attributes\tags that exist for MX6.1, then you can download and install "Tag Updaters" found on Macromedia's downloads...

Hi deepatpaul, Even though you can access your object in the same manner as an associative array (structure), the object is still a query object. Running the function isStruct() will yeild false, so it is not neccessary for you to initialize the variable with an empty structure. In anycase...

csteinhilber, Any luck adding\registering the cfx tags? I'd be interested to find out the outcome. jalpino