On error Resume next in ASP

Question

HI,

I want to catch SQL error in my Page.If I use "On error Resume next" ,If page having some other error it wont thrown .Can u plese give solution for handling error

Answer 1

You can revert the standard exception raising by using

ON ERROR GOTO 0

http://www.powerasp.com/content/new/on-error-resume-next.asp

Answer 2

Also, don't forget that if you put On Error Resume Next in a Sub or a Function it will only apply to that Sub/Function.