User Friendly Error Messages

Question

Post reply

User Friendly Error Messages

sfm

Old Hand

Points: 394
More actions
December 17, 2003 at 2:10 am

#84930

Hi,
I was wondering how I could give user friendly error messages given a particular error. I am using SQL Server Stored Procs and ASP/VBScript.
Any links/advice would be appreciated!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

Would this help?

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=18138

http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=18119

Frank

http://www.insidesql.de

http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

sfm Old Hand Points: 394 More actions · Answer 2

Thanks for the links Frank. I was thinking along the lines of returning an error...but then redirecting the user to another page that confirms the error occurred, is this possible?

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

Oh sorry,

Something like this should work



On Error Resume Next

....

your db statement

Select Case Err.Number

Case.....

    Response.Redirect somewhere else

End Select

I bet there are lots of examples on ASP sites. Might be worth a try.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

sfm Old Hand Points: 394 More actions · Answer 4

Thanks again, that´s exactly what I was looking for.