don't use a '*' in the delete statement on SQL7
At 11:11 AM 11/30/00 -0500, you 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/[email protected]/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Sincerely yours,
Jim Gurfein
President, CEO
RestaurantRow.com, Inc.
http://www.restaurantrow.com
914.921.3200 ext 101
914.921.9190 fax
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
