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:267981
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
