Are you trying to cache the query?
"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -----Original Message----- From: Bryan Stevenson To: CF-Talk Sent: Tue Mar 20 04:51:01 2007 Subject: Query that should run but won't (but does run) 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. Things I've tried: -trimming it -val() (it's an integer) -int() -#myVar# -<cfqueryparam value="#myVar#" cfsqltype="cf_sql_numeric"> (also tried cf_sql_integer) -clearing the template cache -restarting CF services I'm at a total loss. I've seen some queries that won't run with CFQUERYPARAM in which case I removed it and just use the raw variable (#myVar#), but this time it just won't run unless I hardcode it!! Yes I have also checked the debugging output, and it shows the correct value being used for that param!!! There is some serious weirdness afoot and this is NOT the time for it :-( HELP!!! TIA Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:273067 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
