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 > Hmm, so it failed even when you used these explicit strings? Very odd. I > have seen errors like you had when SQL tries to be smart and convert a > value > based on values already in, but usually only via old DTS. > > I will check later, when my kids are all in bed! > > > > > > > > "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, > Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, > Registered in England, Number 678540. It contains information which is > confidential and may also be privileged. It is for the exclusive use of > the > intended recipient(s). If you are not the intended recipient(s) please > note > that any form of distribution, copying or use of this communication or the > information in it is strictly prohibited and may be unlawful. If you have > received this communication in error please return it to the sender or > call > our switchboard on +44 (0) 20 89107910. The opinions expressed within > this > communication are not necessarily those expressed by Reed Exhibitions." > Visit our website at http://www.reedexpo.com > > -----Original Message----- > From: [EMAIL PROTECTED] > To: CF-Talk > Sent: Sun Jun 17 13:52:22 2007 > Subject: Re: Error converting data type varchar to int. > > 'TestUsername' and 'TestPassword' is what i've been using for testing. > > <cfprocparam value="testusername" variable="MemberUsername" > cfsqltype="cf_sql_varchar" /> > <cfprocparam value="testpassword" variable="MemberPassword" > cfsqltype="cf_sql_varchar" /> > > Rob > >> What are the respective values of @MemberUsername and @MemberPassword? >> >> >> >> >> "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, >> Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, >> Registered in England, Number 678540. It contains information which is >> confidential and may also be privileged. It is for the exclusive use of >> the >> intended recipient(s). If you are not the intended recipient(s) please >> note >> that any form of distribution, copying or use of this communication or >> the >> information in it is strictly prohibited and may be unlawful. If you >> have >> received this communication in error please return it to the sender or >> call >> our switchboard on +44 (0) 20 89107910. The opinions expressed within >> this >> communication are not necessarily those expressed by Reed Exhibitions." >> Visit our website at http://www.reedexpo.com >> >> -----Original Message----- >> From: [EMAIL PROTECTED] >> To: CF-Talk >> Sent: Sun Jun 17 13:25:43 2007 >> Subject: Re: Error converting data type varchar to int. >> >> Hi Neil, >> >> I tried the truncate method and that didnt have any effect. I created a >> new version of the proc as follows. >> >> <cfquery name="LOCAL.qUpdate" datasource="SecurityModel"> >> CREATE PROC Proc_Credential_Create >> @User_ID INTEGER >> , @MemberUsername VARCHAR(128) >> , @MemberPassword VARCHAR(128) >> AS >> INSERT INTO Credential(User_ID, MemberUsername, >> MemberPassword) >> VALUES (@User_ID, CAST(@MemberUsername AS >> VARCHAR(128)), >> CAST(@MemberPassword AS VARCHAR(128))) >> </cfquery> >> >> And that appears to run without error and enters the data into the table >> no worries!! So that fixes it, just seems wierd that was have to cast >> that >> datatype. >> >> I've also added you to MSN now, >> >> Thanks, >> >> Rob >> >> >> >> >> >> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281414 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
