Hey folks, Still having this issue, and would like some more eyes on it, if possible. Below is my original post from earlier this week.
> 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. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290182 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
