I'm trying to count the number of records that are ACTUALLY DELETED in the following query. Is there a way to do this? I know the query runs over 100 records but I want to know, say that 50 were matches and got deleted.
<cfoutput query="AmazonItem"> <cfquery name="DelDescriptions" datasource="MediaPost"> Delete From Descriptions Where Des_Id = #AmazonItem.Id# </cfquery> </cfoutput> Thanks in advance! Mark Kecko The Computer Guy MediaPost Communications [EMAIL PROTECTED] http://www.mediapost.com (203)222-0330 ext309 "Imagination is the one weapon in the war against reality." Jules de Gaultier ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists