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. Rob -----Original Message----- From: Dean Lawrence [mailto:[EMAIL PROTECTED] Sent: 15 June 2007 22:41 To: CF-Talk Subject: Re: Error converting data type varchar to int. Rob, Hmmm, it certainly appears to be passing in an int and 2 strings. What is killing me is that I know I had run up against this error in the past, and for the life of me, I cannot remember exactly what the problem was. You may want to double check the field names and types that are defined in SQL Server to make sure that you are not trying to insert param2 and param3 into a field that has been defined as an int. Dean -- __________________________________________ Dean Lawrence, CIO/Partner Internet Data Technology 888.GET.IDT1 ext. 701 * fax: 888.438.4381 http://www.idatatech.com/ Corporate Internet Development and Marketing Specialists ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now 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:281365 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
