469,270 Members | 1,784 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,270 developers. It's quick & easy.

Error Question

Lets say I have a page where a user can update their profile
information. In the DB table the username field has a unique
constraint on it to keep username from repeating. If the user changed
their username to something that already existed in another record in
that table sql will throw an error. That also means that IIS will
give an error page.

I was wondering how I can keep the user on the same page but display
the SQL error message somewhere on the page.

Oct 24 '08 #1
1 1312
Mangler wrote on 24 okt 2008 in microsoft.public.inetserver.asp.general:
Lets say I have a page where a user can update their profile
information. In the DB table the username field has a unique
constraint on it to keep username from repeating. If the user changed
their username to something that already existed in another record in
that table sql will throw an error. That also means that IIS will
give an error page.

I was wondering how I can keep the user on the same page but display
the SQL error message somewhere on the page.
Read up about:

On Error Resume Next
On Error GoTo 0

--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)
Oct 24 '08 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Bob Bamberg | last post: by
40 posts views Thread by vfunc | last post: by
35 posts views Thread by jeffc226 | last post: by
16 posts views Thread by john6630 | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.