Quoting Dave Lyons <[EMAIL PROTECTED]>:
>
> the MM update behavior was throwing a ton of errors so i wrote one
> out but its not working.
Define "not working".
> <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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
