Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-11-30 : 00:19:25
|
David writes "I'm designing a web site with ASP and SQLServer to manage a large address database for an organization. I'd like to allow anyone in the organization to submit new addresses or edit existing records. However, I don't want those records to be inserted until an administrator approves them. Transactions seem like a good way to do this, and the administrator can decide to commit or rollback the proposed records. It seems simpler than storing records temporarily in another table.
My specific questions are:
1) Is there a way to start a transaction on one web page and finish it on a second web page much later?
2) How do I generate a list of pending transactions?
3) Am I running a risk of losing the data in the pending transactions if the machine crashes?
4) Am I way of the mark? How else would I do this?
THANKS!" |
|
|
|
|
|
Spreading transactions over multiple ASP web pages?