Hi James, Thanks for the suggestion mate, I've tried changing that but still get the same error. :-(
Thanks, Rob -----Original Message----- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: 16 June 2007 13:44 To: CF-Talk Subject: Re: Error converting data type varchar to int. In the cfstoredproc call, for your int type you still have a maxlength defined, which is only useful for strings: <cfprocparam value="#ARGUMENTS.UserID#" variable="User_ID" cfsqltype="cf_sql_integer" maxlength="128" /> Perhaps it's messing up the assignment to the int - try removing it. On 6/16/07, Robert Rawlins - Think Blue <[EMAIL PROTECTED]> wrote: > Thanks Dean, > > This is confusing the hell out of me. I've checked all the data types in both > the stored proc and the database columns, they are as they should be, into > and two varchars, I even tried changing the column names to make sure they > weren't reserved words or something, but still the same issue. > > What is weird, that if I fire the proc with those values from SSMS like this: > > EXEC Sp_Credential_Create 1, '07C67BA421500B791090E92F4C3D7032', > 'D5534BDE55CAB29E3932D6CE4F211C34' > > Then it works just fine, so I'm guessing the database side of things is just > fine, this must be something in the cf that's causing the problem, it really > is most wierd. > > Thanks for any further ideas you guys have on this. -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281368 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4