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]
- Re: determine number of records deleted Michael Hodgdon
- Re: determine number of records deleted Dick Applebaum
- Re: determine number of records deleted Michael Hodgdon