Could it be that the field "name" is a reseverd word in Access. Jeffrey Haas wrote: > > 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)
-- Cheers Glenn Shukster (Logic Fundamentals Inc.) Thornhill, Ont. Canada Phone:(905)771-6458 Fax:(905)771-6819 www.logicfundamentals.com President of TDUG www.tdug.com - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: Glenn Shukster <[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)
