I'm surprised that statement worked in Access.
The delete statement automatically deletes a whole row. You do not
need to specify a wildcard, or column as you would in a select statement.
<cfquery name="get_auctions" datasource="happytoad">
DELETE from auction_records where auction_id='#id#' and userid='#userid#'
</cfquery>
ibtoad wrote:
>
> 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
--
Jeff Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781
--
Instant Cold Fusion 4.5 | ISBN: 0-07-213238-8
Due out 3rd Quarter 2001
--
DotComIt, LLC
database driven web data using ColdFusion, Lotus Notes/Domino
--
Half of the Alternative Folk Acoustic Duo called Far Cry Fly
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
--
Promise me no dead end streets, and I'll guarantee we'll have a road
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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