oi Tony!! where id in (#form.id#) ?
that what yer talkin bout? -- Critz Certified Adv. ColdFusion Developer Crit[s2k] - <CF_ChannelOP Network="Efnet" Channel="ColdFusion"> ------------------------------------ Tuesday, June 4, 2002, 10:57:01 AM, you wrote: TC> Hi gang, TC> Here's my situation. Let's say I have a query that returns...5 records. In TC> my last column I have a header called delete and a column which displays TC> checkboxes. The name is the same but the values are that of the ID in the TC> SQL 2K DB. When I check them I want to "deletes" them from the DB. My TC> question is this: let's say I check 3 of them, can I do something like: TC> <cfquery datasource="mydatasource" name="deletethese"> TC> UPDATE mytable TC> SET IsDeleted = 1 TC> <cfloop query="deletethese"> TC> WHERE ID = '#form.ID#' TC> </cfloop> TC> </cfquery> TC> If not, how would I go about doing it? TC> Thanks a million! TC> Tony TC> ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
