Alex,
I read about it, indeed very intresting. but I'm not sure wheter it is a
better solution
other then one I have. I just think something is wrong with the syntax.
Why do you think I can't get the @@Rowcount AS Deleted in cfoutput?
DELETE from Orders WHERE
Product_id=#val(Product_id)#
SELECT @@ROWCOUNT AS Deleted
error <cfoutput>#Queryname.Deleted#</cfoutput>
----- Original Message -----
From: "Sicular, Alexander" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, March 01, 2002 1:32 AM
Subject: RE: count delete
> A trigger is like a sneaky piece of code that lurks in the bowls of the
> database. It is 'triggered' when a particular satement is executed... Like
> an insert, delete or update there is also the 'instead of' trigger too.
The
> trigger itself is an actual query that does something, like copy some data
> to some other table or update a counter... Whatever. The application
> (coldfusion,php...) doesn't even need to know of its existence. You do
need
> to create the trigger in the db using create trigger syntax. You could
> always create a cftransaction and put some code (query) before or after
your
> delete, but that is overhead on the cfserver. Read the docs pertaining to
> triggers, they are very usefull for many things and in general good to
know
> about.
>
> Good luck,
>
> Alexander Sicular
> Chief Technology Architect
> Neurological Institute of New York
> Columbia University
> as867 [at] columbia {dot} edu
>
>
> |-----Original Message-----
> |From: Jason Davis [mailto:[EMAIL PROTECTED]]
> |Sent: Thursday, February 28, 2002 6:27 PM
> |To: CF-Talk
> |Subject: Re: count delete
> |
> |
> |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?
> |> |
> |> |
> |> |
> |>
> |
>
______________________________________________________________________
Why Share?
Dedicated Win 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=coldfusionc
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
