Hi
in your SP you can check for the system variable @@error anfter any
statement to see if an error has occured. i.e.
DELETE FRom blah blah ...
IF @@error <> 0
BEGIN
GOTOT ERROR_EXIT
END
..
..
..
..
..
..
..
PROCEDURE_EXIT:
RETURN 0
ERROR_EXIT:
RETURN @@error
This will return the error code to your SP in the cfstatuscode. Remember in
the error handler in the SP to fully "clean-up" - i.e. if you are using
explcit transactions you will need to rollback/committ accordingly
-----Original Message-----
From: Bosky, Dave [mailto:[EMAIL PROTECTED]
Sent: 20 June 2003 13:01
To: SQL
Subject: Confirm a successful execution of a query?
I'm using MS SQL 2000 stored procedures for updating/deleting records on my
website.
When I call a SP that updates/deletes a specific record is there any way to
verify the record was actually updated/deleted?
Is there a certain variable I can check that SQL uses as a flag to indicate
whether a query was successful or not?
Thanks,
Dave
HTC Disclaimer: The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader of this
message is not the intended recipient, or an employee or agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution or copying of this
communication is strictly prohibited. If you have received this
communication in error, please notify us immediately by replying to the
message and deleting it from your computer. Thank you.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
