Dave,
Whats the error?
Stephen
----- Original Message -----
From: "Dave Lyons" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, December 17, 2002 1:02 PM
Subject: update form
> 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
