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 Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273064 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
