An SQL update statement has a different syntax, it look like you are trying
to do an insert. Try
UPDATE user
set firstname = '#form.firstname#', lastname = '#form.lastname#'...
WHERE primarykey = some value
You also need to indicate which row in the table to update by using the
WHERE clause.
> <cfguery name="Update" datasource="reCFM">
> UPDATE user (firstName, lastName, username, password, email, city,
> state, country, zip, sex, sexPref, BDmonth, BDDay, BDYear, height,
> weight, bodyType, eyes, skinTone,hair, race, kids, wantkids, job,
> hobbies, headline, maritualStatus, smoking, drinking, religion,
> education, seeking, aboutME , aboutYOU , activated) VALUES
> ('#FORM.firstName#', '#FORM.lastName#', '#FORM.username#',
> '#FORM.password#', '#FORM.email#', '#FORM.city#', '#FORM.state#',
> '#FORM.country#', '#FORM.zip#', '#FORM.sex#', '#FORM.sexpref#',
> '#FORM.BDmonth#', '#FORM.BDDay#', '#FORM.BDYear#', '#FORM.height#',
> '#FORM.weight#', '#FORM.bodyType#', '#FORM.eyes#',
> '#FORM.skinTone#',
> '#FORM.hair#', '#FORM.race#', '#FORM.kids#', '#FORM.wantKids#',
> '#FORM.job#', '#FORM.hobbies#', '#FORM.headline#',
> '#FORM.maritualStatus#', '#FORM.smoking#', '#FORM.drinking#',
> '#FORM.religion#','#FORM.education#','#FORM.seeking#')
> </cfquery>
user is a reserved word in SQL, escape it or change it. For the rest, we
need to know the schema.
Jochem
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
