Change it to.
<cfquery name="get_auctions" datasource="happytoad">
DELETE auction_records where auction_id='#id#' and userid='#userid#'
</cfquery>
Mark
-----Original Message-----
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 30, 2000 4:11 PM
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
