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



Windows Technology Windows Technology
15 Seconds
4GuysFromRolla.com
ASP 101
ASP Wire
VB Forums
VB Wire
WinDrivers.com
internet.commerce internet.commerce
Partners & Affiliates
ASP 101 is an
internet.com site
ASP 101 is an internet.com site
IT
Developer
Internet News
Small Business
Personal Technology

Search internet.com
Advertise
Corporate Info
Newsletters
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

QUICK TIP:
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:

required
The script will use a transaction, and will participate in any open transaction or create a new one if none are open.
requires_new
The script will always start a new transaction.
supported
The script will use any open transaction but will not start a new one if none are currently open.
not_supported
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: webmaster@asp101.com.


Home |  News |  Samples |  Articles |  Lessons |  Resources |  Forum |  Links |  Search |  Feedback

Internet.com
The Network for Technology Professionals

Search:

About Internet.com

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