I would check the FORM.Password field and see what it's value is. If you have more than one password field on your form, the form variable will be a list containing the values of all the fields..
HTH -R -----Original Message----- From: FlashGuy [mailto:[EMAIL PROTECTED] Sent: Thursday, April 03, 2003 12:17 PM To: CF-Talk 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4