Could be a typo... "maritualStatus" OR if your using SQLServer I believe user is a reserved word so you might have to change the sql to talk to a table [user]
HTH -----Original Message----- From: Dave Lyons [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 17, 2002 13:02 To: CF-Talk 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
