DELETE *
FROM work
?
CC
"Keith Meade" <[EMAIL PROTECTED]> on 05/18/2001 10:04:49 AM
Please respond to [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
cc:
Subject: Re: deleting records in a dbase III table
Can you delete a single record, e.g. delete where key=value ?
----- Original Message -----
From: "Terry Troxel" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 18, 2001 9:16 AM
Subject: Re: deleting records in a dbase III table
: Here is what is returned:
:
: Error Diagnostic Information
: ODBC Error Code = S1000 (General error)
:
: [Microsoft][ODBC dBase Driver] Could not delete from specified tables.
:
: SQL = "delete from work"
:
: Data Source = "test.dbf"
:
: SQL = "delete from work"
:
: The error occurred while processing an element with a general identifier
of
: (CFQUERY), occupying document position (2:1) to (2:52).
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
