<cfquery datasource="master_data">
delete from MasterTable
where MasterID in (#ValueList(GetMasterID.MasterID)#)
</cfquery>
Regards,
Howie Hamlin
--
inFusion Project Manager; On-Line Data Solutions, Inc. (631)737-4668
www.CoolFusion.com
============================================================
Please vote for iMS in the Most Innovative category here:
*** http://www.sys-con.com/ColdFusion/readerschoice2000/ ***
============================================================
Check out inFusion Mail Server - the world's most configurable email server
----- Original Message -----
From: aslam bajaria <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 20, 2000 5:54 PM
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=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
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.
