Error Handling

[joeyramirez]

How can I trap this kind of error?

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[MySQL][ODBC 5.1 Driver][mysqld-5.5.17]Duplicate entry '1218-1-1' for key 'PRIMARY'

/ticksys/data/insertcb.asp, line 17

With this code?I don't know if I did it right.

<%
On Error Resume Next
If Err.Number > 0 Then
%>
<%   
    Response.Write("Error Number -> " & Err.Number)
    Response.write("<BR>Error Source -> " & Err.Source)
    Response.Write("<BR>Error Desc   -> " & Err.Description)
    Err.Clear
%>

<%

    Else
    Response.redirect("editcb.asp?refID="&Request.Form("tnum")&"")
   
    End If
    Conn.Close()  
    Set exec = Nothing  
 %>

[Flakes]

You have to specify the "On Error Resume Next" line before your db execute statement.

[joeyramirez]

how?can you give me a sample?

[joeyramirez]

ok i got it now .thanks Mr. Flakes.

[Doug G]

Remember on error resume next will remain on for the remainder of the page unless you turn it back off with on error goto 0. Also you have to test the err variable immediately after the statement you suspect may fail. The asp error is reset each statement line and if an earlier line caused an error but you test later you will not see the first error correctly.

Classic asp error trapping is pretty much a joke in most cases.

[joeyramirez]

Tnx sir

[John_Betong]

@joeyramirez

How can I trap this kind of error?

HTML Code:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[MySQL][ODBC 5.1 Driver][mysqld-5.5.17]Duplicate entry '1218-1-1' for key 'PRIMARY'

/ticksys/data/insertcb.asp, line 17

The MySQL error occurs because you are trying to insert a Primary Key Value that already exists.

Please show the MySQL Script which I am sure can be modified to eliminate the error.

[joeyramirez]

Dim sql,exec
sql=""
sql=sql &"INSERT INTO tblselectedprob (Ticket,cat,value) VALUES ('"&Request.Form("tnum")&"','"&Request.Form("concern")&"','"&Request.Form("problem")&"') "
Set exec=Conn.Execute(sql)

[John_Betong]

@joeyramirez can you:

1. ECHO your SQL statement
2. supply tablename primary keys

[Doug G]

Not really on topic, but you really shouldn't pass unfiltered request.form data directly to your database or you too may become a victim of sql injection attacks.

[John_Betong]

@joeyramirez can you:

1. ECHO your SQL statement
2. supply tablename primary keys

Can you also check to make sure you have auto-increment set for the Primary Key