Andy Matthews wrote: > 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
Unfortunately, that only gives you the statement that was sent to the database driver, not what the database driver sent to the database. In this case that is relevant because he is sending the value 1.5 to a cfqueryparam with the cfsqltype cf_sql_integer. Somewhere along the way that will either get truncated to 1 or rounded to 2, so you can imagine that it is important to be able to look a little bit deeper then CF allows you to see. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:268009 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
