I think this should work....
<cfloop query="GetmasterID">
<cfquery datasource="master_data" name="delete">
delete from mastertable
where masterid = #masterid#
</cfquery>
</cfloop>
At 02:54 PM 20/06/00 -0700, you wrote:
>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.
