Eric, Here is a browser bookmarklet that will merge your CFDebugging SQL and the query param (if that helps at all).
http://bennadel.com/index.cfm?dax=blog:459.view Of course, this only works if debugging is turned on. ...................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -----Original Message----- From: Eric P [mailto:[EMAIL PROTECTED] Sent: Monday, January 29, 2007 12:44 PM 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:267994 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
