select count(*)
from mytable
where mycity = 'Boston'
</cfquery>
<cfquery datasource="#mydsn#">
delete
from mytable
where mycity = 'Boston'
</cfquery>
HTH
Dick
On May 5, 2004, at 8:09 AM, Michael Hodgdon wrote:
> 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]