Trap SQL Error - asp-db enterprise

**bridgji** · 11-07-2002, 02:15 PM

I have a aspdb grid with editing. The sql table it goes against has an index preventing duplicate values. It comes back with a ugly error when this happens. I want to trap this error and replace it with a nice message but I'm not sure how.

Thanks
jb

**rrenfro** · 11-25-2002, 04:42 PM

I have the same problem. Have you been able to work up a solution?

**Mark** · 11-26-2002, 11:39 AM

Here is one way to do it.
Check for "Records affected" to see if it is equal to ONE. If not, take action.
This code works:

<% response.buffer=true %>
<HTML>
<HEAD><title> ASP-db: EDIT NWIND EMPLOYEES TABLE </title></HEAD>
<BODY>
<%
MYSELF = Request("PATH_INFO")
RQ1 = "ASPdbClick_21"
LASTCLICK = UCASE(Request(RQ1))
Response.write("LASTCLICK=" & LASTCLICK)

Set MyDb = Server.CreateObject("ASP.db")
MyDb.dbUnit = 21
Mydb.dbDSN = "NWIND"
MyDb.dbGridTableTag = "Border=2"
MyDb.dbMode = "Both"
MyDB.dbDebug = 101
Mydb.dbNameMap = "EmployeeID,Emp ID; TitleOfCourtesy,Common Title; PostalCode,Postal Code;"
Mydb.dbButtonAnchor = false

MyDb.dbEditFlds = "1,2,3,4,5,6,7,8,9,10,11,12,13,15,16" ' not 14 (Photo)
Mydb.dbEditParams = "TableName=Employees,BookMarkFlds=0,TableTag=Borde r=2,RecordScope=single"

MyDb.dbSQL = "Select * from Employees"
MyDb.dbImageDir="../images/"
Mydb.dbNavigationItem="Next, Prev, Gridrow, Filter, resetFilter, add, update, delete, reload"
Mydb.dbNavigationIcon="std"

MyDb.ASPdb

RECSAFF = Session("SV_RecAffected_21")
if ((LASTCLICK="APPLYUPDATE" OR LASTCLICK="APPLYADD") AND RECSAFF <> 1) then
Response.Clear
Response.write("CHANGE NOT MADE! ")
Response.write("Be sure that all required fields are filled out properly. ")
Response.write("<A HREF=" & MYSELF & "> click here to continue </A> ")
end if
%>

</BODY>
</HTML>

**bridgji** · 11-26-2002, 12:40 PM

There is also a session variable that is set with the error code. Unfortunatly my co-worker who found it is out. I'll post it when he gets in.

**rrenfro** · 11-26-2002, 01:28 PM

I think it's SV_ERROR_Unit#

I added this code after the call to oDB.ASPdb on my page to see all of the session vars.

x = 1
for each oItem in session.contents
Response.write oItem & " = " & session.Contents(x) & " "
x = x + 1
Next

Thread: Trap SQL Error - asp-db enterprise

Thread Tools

Display

Trap SQL Error - asp-db enterprise

Posting Permissions