Connecting Tech Pros Worldwide Help | Site Map

Error Question

  #1  
Old October 24th, 2008, 08:05 PM
Mangler
Guest
 
Posts: n/a
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.

  #2  
Old October 24th, 2008, 11:25 PM
Evertjan.
Guest
 
Posts: n/a

re: Error Question


Mangler wrote on 24 okt 2008 in microsoft.public.inetserver.asp.general:
Quote:
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)
Closed Thread


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error question. JoeC answers 4 September 18th, 2006 09:35 PM
Request Timeout Error Question Steve Taylor answers 3 November 18th, 2005 11:00 PM
Visual C++ Forms error question Martijn answers 1 August 4th, 2005 02:45 PM
istringstream syntax error question Donald Canton answers 1 July 22nd, 2005 06:57 AM
wc3 Validation error question bill drescher answers 4 July 21st, 2005 12:19 AM