Nevermind...I found the problem. I had a <input> tag with a "hidden" field along with a "text" field.
On Thu, 03 Apr 2003 12:56:05 -0500, FlashGuy wrote: > WTF > > > Here is my code: > > <cfquery name="UpdateUser" datasource="#Request.App.dsn#"> > UPDATE login > SET > Username=<cfqueryparam value="#FORM.Username#" > cfsqltype="CF_SQL_LONGVARCHAR">, > Password=<cfqueryparam value="#FORM.Password#" > cfsqltype="CF_SQL_LONGVARCHAR">, > Firstname=<cfqueryparam value="#FORM.Firstname#" > cfsqltype="CF_SQL_LONGVARCHAR">, > Lastname=<cfqueryparam value="#FORM.Lastname#" > cfsqltype="CF_SQL_LONGVARCHAR">, > Level=<cfqueryparam value="#FORM.Level#" > cfsqltype="CF_SQL_LONGVARCHAR">, > Access=<cfqueryparam value="#FORM.Access#" > cfsqltype="CF_SQL_LONGVARCHAR">, > Status=<cfqueryparam value="#FORM.Status#" > cfsqltype="CF_SQL_LONGVARCHAR"> > WHERE UserID=<cfqueryparam value="#FORM.UserID#" > cfsqltype="CF_SQL_LONGVARCHAR"> > </cfquery> > > When I update the password field it doesn't get inserted and then the username filed > gets a duplicate name inserted. > > username field = "bob,bob" > > > If I try setting the password again and hit submit I get. > > username field = "bob,bob,bob,bob" > > and so on. > > The output of the variables for the UserID are: > > UsrID: 9,9 > FORM.UserID: 9,9 > > Why is the an extra figure concatenated on the end? > > > > > > On Thu, 3 Apr 2003 09:28:12 -0800, Bryan Stevenson wrote: > > > WHERE #FORM.UserID# > > > > Should be something like: > > > > WHERE User_ID = #FORM.UserID# (and you should use CFQUERYPARAM here as > > well) > > > > Bryan Stevenson B.Comm. > > VP & Director of E-Commerce Development > > Electric Edge Systems Group Inc. > > t. 250.920.8830 > > e. [EMAIL PROTECTED] > > > > --------------------------------------------------------- > > Macromedia Associate Partner > > www.macromedia.com > > --------------------------------------------------------- > > Vancouver Island ColdFusion Users Group > > Founder & Director > > www.cfug-vancouverisland.com > > ----- Original Message ----- > > From: "FlashGuy" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Thursday, April 03, 2003 9:16 AM > > Subject: re: <cfquery> UPDATE > > > > > > > Hi, > > > > > > Whats wrong with the syntax below? When I change a field and click the > > submit to run the code below it "adds" the field to the existing field in > > the database. > > > I want to replace it. > > > > > > For example the password is "test". Using my template I enter in "xxx" > > click the submit. When I check the database I have "test,xxx" in the > > password field. > > > I just want "xxx". > > > > > > <cfquery name="UpdateUser" datasource="#Request.App.dsn#"> > > > UPDATE login > > > SET > > > Username=<cfqueryparam value="#FORM.Username#" > > cfsqltype="CF_SQL_LONGVARCHAR">, > > > Password=<cfqueryparam value="#FORM.Password#" > > cfsqltype="CF_SQL_LONGVARCHAR">, > > > Firstname=<cfqueryparam value="#FORM.Firstname#" > > cfsqltype="CF_SQL_LONGVARCHAR">, > > > Lastname=<cfqueryparam value="#FORM.Lastname#" > > cfsqltype="CF_SQL_LONGVARCHAR">, > > > Level=<cfqueryparam value="#FORM.Level#" cfsqltype="CF_SQL_LONGVARCHAR">, > > > Access=<cfqueryparam value="#FORM.Access#" > > cfsqltype="CF_SQL_LONGVARCHAR">, > > > Status=<cfqueryparam value="#FORM.Status#" cfsqltype="CF_SQL_LONGVARCHAR"> > > > WHERE #FORM.UserID# > > > </cfquery> > > > > > > > > > --------------------------------------------------- > > > Colonel Nathan R. Jessop > > > Commanding Officer > > > Marine Ground Forces > > > Guatanamo Bay, Cuba > > > --------------------------------------------------- > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
