-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
You should be able to do the following:
<cfquery name="GetMasterID" datasource="master_data">
DELETE FROM MasterTable
WHERE SignUpDate = #SignUpDate#
</cfquery>
Or
<cfquery name="GetMasterID" datasource="master_data">
DELETE FROM MasterTable
WHERE MasterID IN (
select masterID
from MasterTable
where SignUpDate = #SignUpDate#
)
</cfquery>
Hope that helps.
Best regards,
Zac Bedell
========================================
Zachary S. Bedell,
Chief Technology Officer,
Adirondack Technologies, Inc.
Please include original message in any replies -- I get a
lot of email every day, and I have a REALLY bad memory...
So I don't always remember everything that was said.
Thanks!
> -----Original Message-----
> From: aslam bajaria [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 20, 2000 5:55 PM
> To: [EMAIL PROTECTED]
> Subject: Help!
>
>
> I have come across a problem that has to be solved
> today.
>
> I have a query that gets the list of all the MasterIds
>
> under some conditions:
>
> <cfquery name="GetMasterID" datasource="master_data">
> select masterID
> form MasterTable
> where SignUpDate = #SignUpDate#
> </cfquery>
>
> My goal is to delete all the masterids I get from this
> query. Can someone tell me how to do it?
>
> Appreciate.
> A.B.
>
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages with Yahoo! Messenger.
> http://im.yahoo.com/
> --------------------------------------------------------------
> ----------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> s/cf_talk or send a message to
> [EMAIL PROTECTED] with 'unsubscribe' in the body.
>
-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.2 for non-commercial use <http://www.pgp.com>
Comment: Please use PGP!!!
iQA/AwUBOU/oxwraVoMWBwRBEQK20wCgqwa8AqOXNldvwCRlQ2KUIsZbRGwAoJjp
LlypnTcNnISQKxa0kVjuAT8d
=yvdM
-----END PGP SIGNATURE-----
------------------------------------------------------------------------------
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.
