How to catch SQL Exception in ASP?

I have make a SQL Statement to insert into db:

strSQL = "insert into lgr_logreg values(" + strUI + ",'" + strPassword + "','" + strEmail + "','" &_
 strTel + "','" + strRank + "','" + strPosition + "','" + strFullname +"','" + strRemoteIP + "','2001-07-01','test');"

This is true that sometimes the user will insert duplicated Primary Key Value. So, how can catch the SQL exception of ASP or can i test the statement to return boolean for me ? like

trueOrFalse = connection.Execute(strSQl)

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK_lgr_logreg'. Cannot insert duplicate key in object 'lgr_logreg'.
/regpoint.asp, line 33


Please give me some code example. Thanks!
john_law70Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
weesiongConnect With a Mentor Commented:
john_law70,

StrSQL = "Select strUI from lgr_logreg where strUI =" +strUI
Rs.open StrSQL, conn, 1, 3
IF Not Rs.Eof Then
   Response.Write("Sorry canot using this userid")
   Response.End
Else
strSQL = "insert into lgr_logreg values(" + strUI + ",'" + strPassword + "','" + strEmail + "','" &_
strTel + "','" + strRank + "','" + strPosition + "','" + strFullname +"','" + strRemoteIP + "','2001-07-01','test');"
End IF

Regards,
WEe Siong
0
 
holymudCommented:
on error resume next

....
Execute (sql)


if err <> 0 then    ' an error has occurred
' now u have the error number and descriotion

resposne.write err.number
resposne.write err.description

err.clear     'dont forget to clear the error
end if
0
 
weesiongCommented:
join_law70,

Questions Asked 6
Last 10 Grades Given A D  
Question Grading Record 2 Answers Graded / 2 Answers Received

5 11/16/00 100 VB-How to save binary data to a file? UnlockedQ

Please close Open Question

Regards,
Wee Siong
0
 
deestuarCommented:
Howe about putting in some transaction management in the database and use raiserror when an exception occurs. You could code your insert statment into a server side stored procedure ?
0
All Courses

From novice to tech pro — start learning today.