Haven't used Access in a while, but I'm pretty sure you have to place a
";" at the end of your statement, as in:
insert into tbl_users (fullname) values ('Rich Pragel') where
username = rpragel;
Also, put single quotes around rpragel. (i.e. 'rpragel')
Mark
-----Original Message-----
From: James Taavon [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 25, 2001 12:18 PM
To: CF-Talk
Subject: Semicolon at end of SQL Statement???
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
