Try just DELETE FROM <table> WHERE <conditions>
You'd have to use UPDATE to delete/mangle individual cell data, so the * in
the previous statement is unnecessary. :)
--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC 28270
www.solutionmasters.com
704.563.5559 x 228 Voice
704.849.9291 Fax
-----Original Message-----
From: ibtoad <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Date: Thursday, November 30, 2000 2:24 PM
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
