Not sure about the semi colon.....
But in "..username = rpragel " if rpragle is a string u will need tics
"..username = 'rpragel' "
----- Original Message -----
From: "James Taavon" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, October 25, 2001 11:17 AM
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>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.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
