Nope, everything is fine within the database, triple checked. Nulls are allowed
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Karl Zarudny Sent: March 19, 2002 12:47 PM To: [EMAIL PROTECTED] Subject: Re: [CFTALKTor] Insert Statement Any chance of field violations?.... field lengths, types - trying to insert a string where it should be a integer, null values in a field where nulls are not permitted? I take it your query starts on line 39? Are there any fields that are required in your db and which are not permitted to have a null value, that you are not providing when you complete the form? Beats me. Anyone else have any ideas on this? > From: "Andrew Green" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Tue, 19 Mar 2002 15:39:04 -0800 > 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: 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)
