You don't need the * ... DELETE FROM will work just fine.
Todd Ashworth
----- Original Message -----
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 30, 2000 11:11 AM
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
