the MM update behavior was throwing a ton of errors so i wrote one out
but its not working.
can anyone please look it over and see where i'm messing up
thanks!
<!-------------------update
record-----------------------------------------------
<cfif isdefined("form.update_profile")>
<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>
----------------------------end update------------------------------>
Dave
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
