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.
