Custom Error Message When Database Not Updated


R

RoadKill

I have ASP forms to update my database. However if someone tried to submit a
duplicate entry, it just gives an ugly ASP error message that makes no sense
to an average user.

How can I create a custom error message when this happens. I am assuming an
If then statement can be applied to the Insert command but am not sure how to
pull that off.

Thanks!

strSQL = "INSERT INTO NewResults(Supervisor, Q1, Q2, Q3, Q4, Q5, Q6, Q7, Q8,
Q9, Q10, User_name, PostedOn, ReviewType, Center) Values('" &
request.form("Supervisor") & "', '" & request.form("Q1") & "', '" &
request.form("Q2") & "', '" & request.form("Q3") & "', '" &
request.form("Q4") & "', '" & request.form("Q5") & "', '" &
request.form("Q6") & "', '" & request.form("Q7") & "', '" &
request.form("Q8") & "', '" & request.form("Q9") & "', '" &
request.form("Q10") & "', '" & request.form("User_name") & "', '" &
request.form("PostedOn") & "', '" &
request.form("ReviewType") & "', '" & request.form("Center") & "')"
 
Ad

Advertisements

J

Jon Spivey

Hi,
You can switch off the default asp error message like this

strSQL="..."
on error resume next
YourConnection.execute strSQL
if err.number <> 0 then
' put your own message here
' you could also write to a log email the webmaster etc
end if
on error goto 0 ' switch back to asp error handling


Cheers,
Jon
 
Ad

Advertisements

S

Stefan B Rusynko

While you can add a custom error message, you really don't want the database to ever generate an error from a duplicate record event
- by that time the error has occurred and the server side processing has ended

The correct ways to do it is to check for possible duplicate before you even attempt to insert the record
- usually by just running a query to check for a record with the key fields that you don't want duplicated (because they are set as
unique in the database)

Typically you would have a duplicate record check before the insert
<%
'query the DB for the record opening it with say objrs
'(using the form values of the key fields)
IF NOT objrs.EOF THEN ' check if record found
'The record was found so it would be a dupe if inserted
' close the dupe check record set
' Add your custom error message here and a link back to the form here
ELSE ' record not found so not a dupe
' close the dupe check record set
' include your insert record code here
END IF
%>




I have ASP forms to update my database. However if someone tried to submit a
duplicate entry, it just gives an ugly ASP error message that makes no sense
to an average user.

How can I create a custom error message when this happens. I am assuming an
If then statement can be applied to the Insert command but am not sure how to
pull that off.

Thanks!

strSQL = "INSERT INTO NewResults(Supervisor, Q1, Q2, Q3, Q4, Q5, Q6, Q7, Q8,
Q9, Q10, User_name, PostedOn, ReviewType, Center) Values('" &
request.form("Supervisor") & "', '" & request.form("Q1") & "', '" &
request.form("Q2") & "', '" & request.form("Q3") & "', '" &
request.form("Q4") & "', '" & request.form("Q5") & "', '" &
request.form("Q6") & "', '" & request.form("Q7") & "', '" &
request.form("Q8") & "', '" & request.form("Q9") & "', '" &
request.form("Q10") & "', '" & request.form("User_name") & "', '" &
request.form("PostedOn") & "', '" &
request.form("ReviewType") & "', '" & request.form("Center") & "')"
 

Similar threads

R
Replies
2
Views
1K
Hot-text
H
R
Replies
1
Views
897
Stefan B Rusynko
S
J
Replies
3
Views
122
Dave Peterson
D
E
Replies
7
Views
189
RagDyeR
R
J
Replies
0
Views
102
JOM
J
P
Replies
0
Views
89
Pam Hatfield
P
J
Replies
0
Views
199
JOM
J
M
Replies
1
Views
112
mrice
M
Top