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
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
