> The correct way in ANSI SQL
> would be something Like
>
> DELETE FROM SystemQuote WHERE CFID Exists IN
> (
> Select CFID
> FROM SystemQuote
> WHERE (CFID=#CFID# AND CFTOKEN=#CFTOKEN#)
> )
>
> Check the syntax but something like that .....
Isn't that exactly the same as;
DELETE FROM SystemQuote WHERE CFID=#CFID# AND CFTOKEN=#CFTOKEN#
Seems to be to me... since the CFIDs returned from the sub-query are the
same as the ones in the Where, you might as well not run the sub-query
Also, this query (and the sub-query version) won't crash if you have no
entries in the database to delete.
Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
