>From: Russ [mailto:[EMAIL PROTECTED] >We have this stored procedure. It works fine if I comment out @imageHeader >declaration, but once I put it in, and pass it in, I get an error from CF >saying >[Macromedia][SQLServer JDBC Driver]Value can not be converted to requested >type.
Are you using MX? If so, the dbvarname attribute is no longer used. Positional notation is used. Anyway, it sounds like your cfsqltype is not matching up with the type of data you are passing in the value attribute. Try outputting the values before running the storedproc to ensure the proper data is being passed in. Also, I'd use Trim() and Val() around the appropriate variables... Mike ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183815 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
