'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 > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:281412 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4