sybperl-l Archive

From: "Ronan O'Ciosoig" <ronanoc at mac dot com>
Subject: more results pending
Date: Aug 1 2002 11:52AM

After running this code below.....

        $dbh->dbcmd($sql_command);
        $dbh->dbsqlexec;
        while($dbh->dbresults != NO_MORE_RESULTS) {
            $status = $dbh->dbresults;
            print "Status: $status\n";
          while(@updates = $dbh->dbnextrow) {
          print "Zone Update: @updates\n";
          }
        } # end while


And printing out the results, I then try to insert data into the 
database using the same kind of construct i get the following error 
message:


DB-Library error:
         Attempt to initiate a new SQL Server operation with results 
pending.


How can I avoid this happening, and is there any way of catching error 
messages or conditions so that I can have code to deal with them? As in 
the  try ... catch kind of way?

Thanks. Ronan.

One Louder Recordings
Dublin. Ireland.