>Example code. ><cfquery name="test" datasource="myDS"> > select <cfqueryparam cfsqltype="cf_sql_integer" value="1.5"> ></cfquery>
I was under the impression that CFQUERYPARAM just validates and typecasts the value as you specify... so you would get something like (not sure of exact syntax being sent) SELECT CAST(1.5 as integer) Which would return 1 row with an unnamed column value of either 1 or 2, depending on how the rounding goes, which is probably not what you are wanting. If you want to use the cfqueryparam value in a search, you would need to do something like: SELECT FROM TableName WHERE ColumnName=<cfqueryparam cfsqltype="cf_sql_integer" value="1.5"> Unless there's something I'm missing, which there very well may be. I don't use cfqueryparam myself.. -- Pat ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:268316 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
