//<cfguery> <cfquery maybe.... ?
J -----Original Message----- From: Dave Lyons [mailto:[EMAIL PROTECTED]] Sent: 17 December 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
