Cfoutput the query, replace the query params with the values being passed in. Or, if you're using MX7, there's a variable that gets returned with every query which shows you the exact statement sent to the db server.
[Queryname].sql -----Original Message----- From: Eric P [mailto:[EMAIL PROTECTED] Sent: Monday, January 29, 2007 11:44 AM To: CF-Talk Subject: Showing actual used value from cfqueryparam tag I have a query that's giving me some grief, and it would be helpful if I could see the actual used value that the cfqueryparam tag is actually sending to the database. Example code. <cfquery name="test" datasource="myDS"> select <cfqueryparam cfsqltype="cf_sql_integer" value="1.5"> </cfquery> ---------debug output------------------- test (Records=1, Time=0ms) SQL = select ? Query Parameter Value(s) - Parameter #1 = 1.5 -------------------------------------------- So as you can see, the debug tells me what went into Parameter #1 (1.5), but not what was actually used in the query (should be 1). Any ideas for an easy way to get this value? BTW, I'm running CF 5/MS-SQL 2000. Thanks for reading! Eric P. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267986 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
