This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFB54D.70741310 Content-Type: text/plain; charset="iso-8859-1" That was it the group i changed it to groups and it works fine. I knew it was something easy but i couldn't see it thats why I love this list. Shawn Regan -----Original Message----- From: WBB [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 03, 2000 2:10 PM To: [EMAIL PROTECTED] Subject: Re: SQL! i'm losing it Shawn, It may be parsing the field Group and confusing it with GROUP BY, a reserved phrase. I'd try changing the name of the field. > > I have checked and checked this but I cannot see anything wrong with this > code: > > <cfquery name="adduser" datasource="#DSN#"> > insert into users > (user_id,Group,firstname,lastname,Title,email,Password,UserID,ClientID) > values > (#max_ID#,'#trim(attributes.Group)#','#trim(attributes.firstname)#','#trim(a > ttributes.lastname)#','#trim(attributes.Title)#','#trim(attributes.email)#', > '#trim(attributes.Password)#','#trim(attributes.userid)#',#trim(attributes.C > lientID)#) > </cfquery> > > But I keep getting this error: > > ODBC Error Code = 37000 (Syntax error or access violation) > > > [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO > statement. > > > SQL = "insert into users > (user_id,Group,firstname,lastname,Title,email,Password,UserID,ClientID) > values > (2,'External','Shawn','Regan','Webmaster','[EMAIL PROTECTED]','kick','597',2)" > > Anyone see what I am missing? > > Shawn Regan > ---------------------------------------------------------------------------- -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. ------_=_NextPart_001_01BFB54D.70741310 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12"> <TITLE>RE: SQL! i'm losing it FIXED</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>That was it the group i changed it to groups and it = works fine. I knew it was something easy but i couldn't see it thats = why I love this list.</FONT></P> <P><FONT SIZE=3D2>Shawn Regan</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: WBB [<A = HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]</A>]</FONT> <BR><FONT SIZE=3D2>Sent: Wednesday, May 03, 2000 2:10 PM</FONT> <BR><FONT SIZE=3D2>To: [EMAIL PROTECTED]</FONT> <BR><FONT SIZE=3D2>Subject: Re: SQL! i'm losing it</FONT> </P> <BR> <P><FONT SIZE=3D2>Shawn,</FONT> </P> <P><FONT SIZE=3D2>It may be parsing the field Group and confusing it = with GROUP BY, a reserved</FONT> <BR><FONT SIZE=3D2>phrase. I'd try changing the name of the = field.</FONT> </P> <BR> <P><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> I have checked and checked this but I cannot = see anything wrong with this</FONT> <BR><FONT SIZE=3D2>> code:</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> <cfquery name=3D"adduser" = datasource=3D"#DSN#"></FONT> <BR><FONT SIZE=3D2>> insert into users</FONT> <BR><FONT SIZE=3D2>> = (user_id,Group,firstname,lastname,Title,email,Password,UserID,ClientID)<= /FONT> <BR><FONT SIZE=3D2>> values</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT = SIZE=3D2>(#max_ID#,'#trim(attributes.Group)#','#trim(attributes.firstnam= e)#','#trim(a</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT = SIZE=3D2>ttributes.lastname)#','#trim(attributes.Title)#','#trim(attribu= tes.email)#',</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT = SIZE=3D2>'#trim(attributes.Password)#','#trim(attributes.userid)#',#trim= (attributes.C</FONT> <BR><FONT SIZE=3D2>> lientID)#)</FONT> <BR><FONT SIZE=3D2>> </cfquery></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> But I keep getting this error:</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> ODBC Error Code =3D 37000 (Syntax error or = access violation)</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> [Microsoft][ODBC Microsoft Access Driver] = Syntax error in INSERT INTO</FONT> <BR><FONT SIZE=3D2>> statement.</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> SQL =3D "insert into users</FONT> <BR><FONT SIZE=3D2>> = (user_id,Group,firstname,lastname,Title,email,Password,UserID,ClientID)<= /FONT> <BR><FONT SIZE=3D2>> values</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT = SIZE=3D2>(2,'External','Shawn','Regan','Webmaster','[EMAIL PROTECTED]','ki= ck','597',2)"</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> Anyone see what I am missing?</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> Shawn Regan</FONT> <BR><FONT SIZE=3D2>></FONT> </P> <BR> <P><FONT = SIZE=3D2>---------------------------------------------------------------= ---------------</FONT> <BR><FONT SIZE=3D2>Archives: <A = HREF=3D"http://www.eGroups.com/list/cf-talk" = TARGET=3D"_blank">http://www.eGroups.com/list/cf-talk</A></FONT> <BR><FONT SIZE=3D2>To Unsubscribe visit <A = HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli= sts/cf_talk" = TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists= &body=3Dlists/cf_talk</A> or send a message to = [EMAIL PROTECTED] with 'unsubscribe' in the = body.</FONT></P> </BODY> </HTML> ------_=_NextPart_001_01BFB54D.70741310-- ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.