sybperl-l Archive

From: Troy Taylor <ttaylor at JCLLC dot COM>
Subject: trapping errors with db-lib
Date: Mar 13 2000 9:15PM

I have spent hours looking through the Sybperl DBLib docs and cant figure
out how to trap errors like this:

Msg 102, Level 15, State 1
Server 'sybaseserver', Line 4
        Incorrect syntax near 'searchterm'.
DB-Library error:
        General SQL Server error: Check messages from the SQL Server.

This error causes my script to crash.  I am doing error trapping using
$status = $dbh->dbretstatus; BUT it doesnt seem to trap the above kinds of
errors.  My sql syntax is built on the fly, so I need to trap the above
types of errors if they occur.

Thanks for any help in advance, Sorry if this question has been covered
before.  If it has been covered before any points to the correct reference
would be greatly appreciated!

Thanks again!

Troy D. Taylor