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?
|
|
|
______________________________________________________________________
Get Your Own 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=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
