Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (39:1) to (39:46). Date/Time: 03/19/02 15:34:26 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows 98; Win 9x 4.90) Remote Address: 192.168.1.1 HTTP Referrer: http://dev.buildingwealth.ca/forums/Register.cfm -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Karl Zarudny Sent: March 19, 2002 12:21 PM To: [EMAIL PROTECTED] Subject: Re: [CFTALKTor] Insert Statement What specifically is CF reporting? Which line is it saying the error is occurring on? Is there any other code on the page other than the insert? Also, why are you naming your insert query?... Are you performing more than one query within your cfquery? I cleaned up the formatting to make it a little easier to read, but I'm stumped too. Let me know the solution when you find it. - Karl <cfquery datasource="forums"> 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> > From: "Andrew Green" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Tue, 19 Mar 2002 14:52:31 -0800 > To: <[EMAIL PROTECTED]> > Subject: RE: [CFTALKTor] Insert Statement > > Nope...added it in and still getting a syntax error > > > > > -----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) - 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)
