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

Reply via email to