|
|
|
|
|
| | |
|
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)

|
|
Subject: |
transactions on multiple pages? |
From: |
David Askov |
Date: |
11/26/2000 2:01:38 PM |
IP: |
209.141.218.66 |
I have an address database that will be maintained via SQL Server & ASP web pages. Anyone in the organization can input new records, but the proposed changes need to be approved by an administrator before they are inserted in the DB.
My thought was that the proposed change could be started as a transaction. The administrator then would commit or roll back the transaction. Problem is, every tutorial Ive ever seen on this matter describes doing the entire transaction on one web page. Ill need to spread this out over at least two pages. Here are my specific questions:
1) How would I start a transaction on one web page and then commit it or roll it back on a 2nd web page?
2) How can I create a list of transactions that are pending approval?
3) If this cant be done, how else should I do it? I guess I could insert the values into the database, but just flag them as "pending approval".
THANKS! |
|
|

|
|
|
|
|
|
|
|
|
|