><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>
Is either User_ID or ClientID a text field in the database? Those two
fields are the only ones not surrounded by ' '. Also, I've always had bad
luck with an access database and the database field who's name is 'email'.
It may be a reserved word.
Sincerely,
Rob Sherman
------------------------------------------------------
Developer / Allaire Certified Instructor
Email:[EMAIL PROTECTED]
ICQ:_________________________3266081
AIM:______________________RobSSherm
Yahoo!:____________RobSherman_CFDev
Office:__________________(310) 543-1622
Office Fax:______________(310) 543-0512
VMail/Fax:______(310) 754-6016 ext. 5630
------------------------------------------------------------------------------
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.
