���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]
