Hello guys,
I've got a stored proc that enters information into a table on my SQL Server database, and I'm getting the following error message when trying to run it. [Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type varchar to int. This is a snippet of the query details thrown back in the error, it simple takes 3 parameters, the first is an integer and the second 2 are strings/varchar. (param 1) = [type='IN', class='java.lang.Integer', value='1', sqltype='cf_sql_integer'] , (param 2) = [type='IN', class='java.lang.String', value='07C67BA421500B791090E92F4C3D7032', sqltype='cf_sql_varchar'] , (param 3) = [type='IN', class='java.lang.String', value='D5534BDE55CAB29E3932D6CE4F211C34', sqltype='cf_sql_varchar'] The param java types appear to match the cf_sql_type. These types also match those defined inside the stored proc and the table columns, I can't see what's causing this issue. Any ideas? Thanks, Rob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281164 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4