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 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281367 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
