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.
