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?
I want to know the method of doing rollback in ASP.
Like in java we can use Connection.RollBack for this.
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.
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.
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?