ASP 101 - Active Server Pages 101 - Web01
The Place ASP Developers Go!

Windows Technology Windows Technology
15 Seconds
ASP 101
ASP Wire
VB Forums
VB Wire
internet.commerce internet.commerce
Partners & Affiliates
ASP 101 is an site
ASP 101 is an site
Internet News
Small Business
Personal Technology

Corporate Info
Tech Jobs
E-mail Offers

ASP 101 News Flash ASP 101 News Flash

 Top ASP 101 Stories Top ASP 101 Stories
Connections, Commands, And Procedures
What is ASP?
VBScript Classes: Part 1 of N

Watch Your Whitespace
Show All Tips >>
ASP 101 RSS Feed ASP 101 Updates

Quick Tips

Transactions in ASP

Transactions are often very helpful for database manipulation. They allow an all-or-none approach - if something, anything, fails then have the whole process fail rather than just part of it. This can ensure proper data manipulation - you won't get half modified rows.

Well, you can do transactions with active server pages too. Just add the directive:

<%@ TRANSACTION = value %>

to the top of your ASP page, and voila! Transactions the easy way, without involving Microsoft Transaction Server (MTS). "value" can be one of the following:

The script will use a transaction, and will participate in any open transaction or create a new one if none are open.
The script will always start a new transaction.
The script will use any open transaction but will not start a new one if none are currently open.
The script will neither initiate nor participate in a transaction.

Previous      Show All Tips      Next

If you have a tip you would like to submit, please send it to:

Home |  News |  Samples |  Articles |  Lessons |  Resources |  Forum |  Links |  Search |  Feedback
The Network for Technology Professionals



Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers