Bob, Try trim(form.varName), or you could check if the incoming form vars are numeric 1st (<cfif isNumeric(form.varName)>)
Also, why not try using <cfqueryparam> with a type of int and see what that does? Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -----Original Message----- From: Robert Ketrick Sent: Monday, July 23, 2007 5:07 PM To: SQL Subject: RE: SQL not answering 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2892 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
