That might do it. When I select more than one, the value then becomes 1,2,4,5.
By using IN, it should work? Thanks Critz! -----Original Message----- From: Critz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 04, 2002 11:02 AM To: CF-Talk Subject: Re: Is this possible to do? 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
