Re: determine number of records deleted

[Michael Hodgdon]

That will work also, minimizes the query and the math involved in the original solution.  Thank you for taking a look

><cfquery datasource="#mydsn#" name="dsn1">
>     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:
>
>>

---

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

---