Richard Cooper wrote: > > I have two pratically identical SQL statements. The only difference is this > line: > > AND RP.productID = <cfqueryparam value="#URL.productID#" > cfsqltype="cf_sql_integer" /> > > When this line is included the output of the decimal field RP.options changes > from 2.50 to 2
Use cf_sql_decimal as the cfsqltype. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275937 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
