ASP Error handling

[ufobaby]

dear all,
i have understood that we can redirect all errors to a custom page and display a whole lot of information to the user etc etc ... but still got a very basic doubt.

Example :
I have a page which uploads a file to the database. There could be errors on this page. how do i do a rollback transaction if an error occurs on this page and avoid updating partial data in the database.

assuming i have the custom error page setup. PLS HELP.

__________

Niraj...
"The unexpected success is not just an opportunity for innovation. It demands innovation."

 

[Veep]

http://www.asp101.com/articles/chris/asptransactions/default.asp

 

[ufobaby]

thanks, i also tried the ADODB Begin / Commit / Rollback Trans it worked... but now another issue with this

say i have a hughe file for upload, and error occures at line number 1000, the program will still continue to read and attempt to write, then at the end it will give anr error and rollback

is there a way to redirect to an error page as soon as the error occurs ?

__________

Niraj...
"The unexpected success is not just an opportunity for innovation. It demands innovation."

 

[Veep]

Maybe something like:

' up at the top
On Error Resume Next

' after you open the connection and start doing stuff
If err <> 0 then
   ' do your clean up
   Response.Redirect("myErrorPage?errDescription=" & err.Description)
End If