I'm sorry, how will triggers help?
----- Original Message -----
From: "Sicular, Alexander" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 01, 2002 1:17 AM
Subject: RE: count delete
> Use an instead of trigger. Check the books online for mssql. Search for
> create trigger.
>
> Good luck,
>
> Alexander Sicular
> Chief Technology Architect
> Neurological Institute of New York
> Columbia University
> as867 [at] columbia {dot} edu
>
>
> |-----Original Message-----
> |From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> |Sent: Thursday, February 28, 2002 6:11 PM
> |To: CF-Talk
> |Subject: count delete
> |
> |
> |How can I find out wheter rows were deleted in a db or not?
> |
> |DELETE from Orders WHERE
> |Product_id=(SELECT TOP 1 Product_id from Product WHERE
> |Product_coupon='foo1')
> |
> |I would like to know how much records were deleted, if any.
> |
> |I tried using this at the end of the query with no luck:
> |
> |SELECT @@ROWCOUNT AS Deleted
> |
> |and then trying to cfoutput > #Queryname.Delete# (no such variable) :(
> |
> |Any help?
> |
> |
> |
>
______________________________________________________________________
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation · $99/Month · Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
