No, just remove the asterisk (*) and it should work fine. In delete queries, it
is assumed that you want to delete all records that match the criteria in the
WHERE clause, unless you explicitly specify which fields to delete.
-- Bruce
> -----Original Message-----
> From: ibtoad [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 30, 2000 10:11 AM
> To: CF-Talk
> Subject: SQL 7.0 Question
>
>
> Ok I just did a local upgrade from Access 2000 to SQL 7.0 and everything
> works great except one statement.
>
> <cfquery name="get_auctions" datasource="happytoad">
> DELETE * from auction_records where auction_id='#id#' and userid='#userid#'
> </cfquery>
>
> Here is the error:
>
> ODBC Error Code = 37000 (Syntax error or access violation)
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near
> '*'.
>
> Is * not the correct syntax for All is SQL 7.0?
>
> Thanks,
> Rich
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Structure your ColdFusion code with Fusebox. Get the official book at
> http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
