I'm getting an odd error when using <cfqueryparam>. I've got the type set to "cf_sql_integer" - the value I'm passing is an integer (even throwing "Int()" into the mix - and yet, I'm getting the error:
[Macromedia][SQLServer JDBC Driver]Value can not be converted to requested type. However, when I remove the <cfqueryparam> and just throw in the raw variable, i.e. "var = #Int(myNumericVariable)#", it works fine. Throwing in some debugger code to check the variable being passed into the script, the length is fine, it passes the IsNumeric() check, everything. It gets better! The same code (with the cfqueryparam call) on my development box works fine. It's on my production box that it hiccups. On top of that, there's another query right after, that's very similar - using a cfqueryparam set for integer, but using a different passed in variable - and it works fine. Both boxes are running CF8 - though there are differences - dev box is still running Win 2k server, and had CF upgraded - while the production box is new, running fresh installs (no upgrades) of Win 2k3 server and CF8. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289969 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
