We are using MX. I kind of figured that positional notation is used, so I
ordered everything properly. Here is what the debugging looks like.
The SQL is { (param 1) = call uspNodeManagerUpdateScreen( (param 2) , (param
3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 8) , (param 9) ,
(param 10) )}
And here is what really gets passed in:
(param 1) = [type='OUT', sqltype='CF_SQL_INTEGER'] , (param 2) = [type='IN',
class='java.lang.Integer', value='7', sqltype='cf_sql_integer'] , (param 3)
= [type='IN', class='java.lang.Integer', value='164',
sqltype='cf_sql_integer'] , (param 4) = [type='IN',
class='java.lang.Integer', value='6426', sqltype='cf_sql_integer'] , (param
5) = [type='IN', class='java.lang.String', value='Home',
sqltype='cf_sql_varchar'] , (param 6) = [type='IN',
class='java.lang.String', value='globalDefault', sqltype='cf_sql_varchar'] ,
(param 7) = [type='IN', class='java.lang.Integer', value='211',
sqltype='cf_sql_integer'] , (param 8) = [type='IN',
class='java.lang.Integer', value='0', sqltype='cf_sql_integer'] , (param 9)
= [type='IN', class='java.lang.String', value='test',
sqltype='cf_sql_varchar'] , (param 10) = [type='OUT',
sqltype='cf_sql_integer']
Russ
-----Original Message-----
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 09, 2004 5:46 PM
To: CF-Talk
Subject: RE: stored proc - Value cannot be converted to the requested type
>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:183816
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
