just to be sure.. you might want to wrap your query in a savecontent variable and dump the results into TOAD... maybe there's something up with the variable?
On 3/20/07, Robertson-Ravo, Neil (RX) <[EMAIL PROTECTED]> wrote: > 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. > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273107 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
