sybperl-l Archive

From: lasteyrie at iname dot com
Subject: problems with "results pending"
Date: Jun 1 1999 9:20AM

	I use this code :

" $genere->dbcmd($sql_cmd);
  $genere->dbsqlexec;
  $genere->dbresults;
  my %dat;
  if (%dat = $genere->dbnextrow(1)) {
    print "$dat{Num}\n";
    print "$dat{Name}\n";
    @date2 = %dat;
    print "$date2[0], $date2[1]\n";
  }
    $genere->dbcmd($sql_cmd2);
    $genere->dbsqlexec;
    $genere->dbresults;
    my %StatusStu;
    %StatusStu = $genere->dbnextrow(1);
    print "$StatusEtud{StatusE}\n";
    print "$StatusEtud{C_Section}\n";    
"

And when i run it, i always got this error :
"
DB-Library error:
        Attempt to initiate a new SQL Server operation with results pending.
"
    I have only one students with this number, then i don't understand why there is this error, and most of all, how can i resolve it ?

**************************************************  
Laurent de Lasteyrie

  e-mail : mailto:lasteyrie@iname.com
  home page : http://www.mygale.org/~xorg
**************************************************
----------------------------------------------------------------
Get your free email from AltaVista at http://altavista.iname.com