determine number of records deleted

[Michael Hodgdon]

I was wondering what people use to determine the number of records a query has deleted.  Basically, how would you make the following code different in order to increase performance?

<cfquery datasource="#mydsn2#" name="dsn1">
   select count(*)
   from   mytable
</cfquery>

<cfquery datasource="#mydsn#">
    delete
    from    mytable
    where   mycity = 'Boston'
</cfquery>

<cfquery datasource="#mydsn2#" name="dsn2">
   select count(*)
   from   mytable
</cfquery>

<cfset variables.recordsdeleted = dsn1.recordcount - dsn2.recordcount>

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---