To quote the bard.."DOH!"
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Karl Zarudny Sent: March 19, 2002 11:31 AM To: [EMAIL PROTECTED] Subject: Re: [CFTALKTor] Insert Statement Yep, I think I see it. You're missing a single quote (') after '#form.name# It's usually the little things that drive ya insane :-) > From: "Andrew Green" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Tue, 19 Mar 2002 14:27:51 -0800 > To: <[EMAIL PROTECTED]> > Subject: [CFTALKTor] Insert Statement > > Can anyone see what I'm doing wrong here? > > <cfquery datasource="forums" name="addmember"> > insert into > members(Name,Email,Handle,login,password,allow,level,memberid) > values('#form.name#,'#form.email#','#form.handle#','#form.login#','#form > .password#',#allow#,'#level#',#nextid#) > </cfquery> > > All but ALLOW and NEXTID are text. ALLOW and NEXTID are numbers. ( 1 and > 2 respectively ) > Cold fusion is saying there is a syntax error > > <http://www.buildingwealth.ca/> > > - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: Karl Zarudny <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Andrew Green" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
