I spoke with Rob, the fix is two-part. First, within the SP the input variable should be set to INT and not INTEGER and also within the column definitions, again within the SP it should be [User_ID] as User_ID is reserved in SQL Server for internal gunbins.
Variable names (dbvarnames) we're deprecated, but made a welcome return in a recent updater/CF8 I believe. -----Original Message----- From: Dean Lawrence [mailto:[EMAIL PROTECTED] Sent: 18 June 2007 16:19 To: CF-Talk Subject: Re: Error converting data type varchar to int. Rob, I think I remember what caused me to have this error. Try removing the variable attribute of the cfprocparam tags. If the variable names do not explicitely match the variables defined in your stored proc, CF will throw an error. Variable names were depriciated in CFMX and were basically ignored. However, in the latest CF7 update they added them back in and it created all kinds of problems for my older code. Dean On 6/17/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Thanks Neil, > > It certainly is very odd, I have no idea what its doing, like you say with > that explicite string definition it should be fine. > > I've sent a mail to my SQL guy to see whether he has any suggestions as to > what might be causing the issue. > > Thanks mate, > > Rob > -- __________________________________________ 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:281492 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4