Custom Error Message When Database Not Updated

[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") & "')"

 

[Kathleen Anderson]

Take a look at the files in the _fpclass folder and see if the error message
is in one of those files - if it is, you can customize it.

--

~ Kathleen Anderson
Microsoft MVP - Expression Web
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
Expression Web Wiki: http://expression-web-wiki.com/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[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

 

[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") & "')"