Ray, I seem to have found a common problem.
My queries work is the data field is a string/character. If the data field is an integer they don't. I use '#FORM.varName#' for strings, and #FORM.varName# for integers. What is the problem? Bob -----Original Message----- From: Ray Thompson [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 1:58 PM To: SQL Subject: RE: SQL not answering OK. Then the next step is turn on debugging and look at the query in the returned information to see what was actually sent to the DB. If a hard coded number works, but a number from your script does not work, then I would suspect the query. I will ask a stupid question. When you hard coded a number was that the same number that would have been selected from the form. I ask because it might be possible that the number that is being returned from your page and used in the query really does not exist in the DB. Is it possible you are pulling the wrong number from the form? (Been there, done that, is why I ask). Ray Thompson Tau Beta Pi (www.tbp.org) The Engineering Honor Society 865-546-4578 -----Original Message----- From: Robert Ketrick [mailto:[EMAIL PROTECTED] Sent: Monday, July 23, 2007 1:34 PM To: SQL Subject: RE: SQL not answering I have been doing the CFDUMP. It looks fine. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2891 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
