Rollback Transactions
I'm implementing a version control system but i need some help
in setting it up.
I use access as the database.
My routines are setup to allow insert, update, delete on the same form.
ADVERTISEMENT
Rollback In ASP
I want to know the method of doing rollback in ASP.
Like in java we can use Connection.RollBack for this.
ADO Rollback
While scouting around this group, I've stumbled upon this ASP script which deals with rolling back transactions -
'-- Error Handler
if oConn.Errors.Count > 0 then
oConn.RollbackTrans
Response.Write("FAIL")
Response.End
Response.write(err.description)
end if
Which has given me pause to wonder if what I am doing is correct. I'm basing my rollback on the err.number not being 0 (sample code below).Is this ok, or should I be using the conn.errors.count property instead?
File System Object Rollback
Is there any way of rollback any changes made by the file system object in
the event of an error. I delete a file and copy one somewhere and the copy
fails is there anyway to rollback the delete. Essentially a file system
version of a transaction.
Commit And Rollback In ASP With JAVASCRIPT LANGUAGE (not VBS)
I need to have transactions control with JAVASCRIPT ASP LANGUAGE (server-side, not client-side...Remember asp can use VBS, JS or Pearlscript).
I have one table A and one table B (1:n) and so i need to use INSERT(table A), SELECT (PK from table A) and INSERT (n times in table B).
In the end, i need to return to ASP if the transaction was commited or rolled back!...if i didn't need that, i could just make a big sql string to send to the database, but if i did, how would i return the result to the asp?
ASP Transactions
Has anyone successfully written an ASP page in JScript that implements transactions with a mySQL database?Please let me know - I'm having difficulty doing this.
View Replies View RelatedTransactions In ASP
For eg:In a asp page i have 2 insert statements & 1 update statements.All these 3 statements I am executing on same asp page by creating a connection object.But I want to make sure that if first 2 insert statements execute successfully, then only 3rd update is executed.
It is possible that after the execution of first 2 insert statements database goes down and 3 rd update statement does not execute at all.In short I want to treat these 3 statements as a single transaction block and ensure that either all the 3 or none of the statements are executed.
How do I control it in asp page?By writing stored procedures in database & executing it as a single transaction block(using begin transaction & abort or commit) it is possible.But is there a way to conrol this using asp?
ASP 3 Transactions And SSI
Using the ASP 3 transaction functionality requires that the transaction flag is set as the very first code row, I understand. I now have a requirement to implement a transaction in one of the pages.
Unfortunately the whole site is based on SSI (server side includes) that are being picked up based on the users preferences. I have an index.asp page that does this selection, which is always loaded first. Is there any way around this, or do you guys have any
other suggestions?
Transactions With MS Access
I have a ASP application with MS Access. I need to use transaction as there are server insert and delete statement.
oConn.beginTrans
Is it a correct way to use transaction? Would the server hang if there are around 10 (or less) concurrent users. Would the whole database being locked while a user is performing transactioin?
Download Transactions
i am developing something , on one of the pages i have a download link. when the user clicks on the link he gets a download box on his screen. i would like to code in such a way that after the download gets completed then his balance stored on the database should be decremented.
View Replies View Related.ASP, MTS Transactions, And Stored Procedure I/O Variables
I've got a webpage that calls some stored procedures with input variables.
The procedures return recordsets and also some output variables. We're
trying to get the values of the output variables. I've done this using the
method I found in MSDN, as shown in the code below. The problem is that we
believe doing it this way involves the use of the Microsoft Transaction
Server (IIS transaction server). Is this true? (The SQL Server and IIS
Server are on different machines and, I believe, a firewall separates them.)
I can't see why this method would use MTS. The problem is that in the past,
we have had problems with MTS stopping for no reason, which causes the
websites to not work. So my boss doesn't want to use any ASP code that
relies on MTS. Not using the stored procedure output variables makes things
way more complicated. So does this code really invoke MTS? And if it does,
is there a way to obtain SP output variables without using MTS?
I am running SQL Server 7.0 with the latest service pack and IIS version 4.
We do have an IIS version 5 server we can use if that matters. Code:
Does OLE DB Provider For MySQL Support Transactions
I am working with MySQL database.
I am using ASP.I am using transaction safe table type InnoDb to create tables in MySQL.
I am accessing these tables from ASP using OLE DB provider for Mysql Version 3.0.When I issue a command like
conn.begintrans
I get the error "Provider does not support Transactions".
Pl. tell me how can I manage transactions for Mysql using the OLE DB provider.I thought of using MyODBC driver,but this driver always gives the recordcount as -1.
Conn.Errors.Count Or Err.Number For Transactions?
What is the best way to control is a transaction? I've done a little test and both of the examples below seem to do the job, but I was wondering which is the better method, this:
If err.number <> 0 Then
conn.RollbackTrans
Else
conn.CommitTrans
End If
Or this:
If conn.Errors.Count <> 0 Then
conn.RollbackTrans
Else
conn.CommitTrans
End If
Require Information On Coding On Credit Card Transactions
Can any1 help me or suggest a helpful link for coding for Credit-card transaction.
View Replies View RelatedLogging Users :: Transactions My Users Perform
I want to be able to log in a database any transactions my users perform. For example logging in, requesting a page, downloading a resource, logging out etc.
What is the most practical way to code this? I was thinking of trying to use an include file which would have a function to add a log in the database for each page on the site or when a particular action is performed.