I sit corrected. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Cheryl Hill Sent: March 19, 2002 4:18 PM To: [EMAIL PROTECTED] Subject: RE: [CFTALKTor] Insert Statement
This link gives reserved words for Access, at least up to 97 ... should be very similar for 2000. http://support.microsoft.com/support/kb/articles/Q109/3/12.asp -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jeffrey Haas Sent: Tuesday, March 19, 2002 4:05 PM To: [EMAIL PROTECTED] Subject: RE: [CFTALKTor] Insert Statement I think the problem is the name of the password column in your database. Test this by dropping 'password' from the insert statement. If it works without it, then you'll need to change your table and the code. Access has certain restrictions on column names. Good luck finding documentation on it, though. Good luck. Jeffrey Haas [EMAIL PROTECTED] ps - My WDDX project continues, but my feeling is that it's like a 95-yard rush that falls 2 yards short of the goal, right before the buzzer sounds. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Andrew Green Sent: March 19, 2002 6:39 PM To: [EMAIL PROTECTED] Subject: RE: [CFTALKTor] Insert Statement 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) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Jeffrey Haas" <[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: "Cheryl Hill" <[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: "Jeffrey Haas" <[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)
