Not that familiar with doing SQL in Access, but this error does not make sense to me.
ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Missing semicolon (;) at end of SQL statement. SQL = "insert into tbl_users (fullname) values ('Rich Pragel') where username = rpragel" Data Source = "DLLR930" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (1:1) to (1:44) in the template file c:\inetpub\wwwroot\DLLR930\insert.cfm. <cfquery name="insert" datasource="dllr930"> insert into tbl_users (fullname) values ('#firstname# #lastname#') where username = #url.username# </cfquery> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists