On 3/19/07, Bryan Stevenson wrote: > Hey All, > > I have a query that no matter how I try and use a variable (in cfqueryparam or not), it returns no records UNTIL I hardcode the value of the variable!!!!!! I might add it runs just fine in TOAD.
Oi! Dang. Don't know what the deal is, but you could try maybe WHERE CAST(theField AS Int) = <cfqueryparam value="#val(myVar)#" cfsqltype="cf_sql_integer"> Or something similar... *shrug* Something is funky. I'm thinking datatype or some such, but I don't know. Force be with you, mate! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273065 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
