One way to do this would be to build a list of the ID's that are to be deleted then use
WHERE ID in (#lstIDs#) Andy -----Original Message----- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 9:57 AM To: CF-Talk Subject: Is this possible to do? Hi gang, Here's my situation. Let's say I have a query that returns...5 records. In my last column I have a header called delete and a column which displays checkboxes. The name is the same but the values are that of the ID in the SQL 2K DB. When I check them I want to "deletes" them from the DB. My question is this: let's say I check 3 of them, can I do something like: <cfquery datasource="mydatasource" name="deletethese"> UPDATE mytable SET IsDeleted = 1 <cfloop query="deletethese"> WHERE ID = '#form.ID#' </cfloop> </cfquery> If not, how would I go about doing it? Thanks a million! Tony ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
