PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Jim Lewis <jrl at ast dot cam dot ac dot uk>
Subject: Re: problems with "results pending"
Date: Jun 1 1999 9:38AM

Hi,

Are you sure you only have one?  Check the command on your server and see
what you get.  Otherwise you can do $genere->dbcancel to get rid of any
other pending results before you call $genere->dbcmd(...) for the next
command.

J

-------------------------------------------------------------------------------
  Jim Lewis                        | 
  Cambridge Astronony Survey Unit  | Phone (direct)    44-(0)1223-766652
  Institute of Astronomy           |       (reception) 44-(0)1223-337548
  Madingley Road                   | FAX               44-(0)1223-337523
  Cambridge CB3 0HA                | 
  UK                               | e-mail            jrl@ast.cam.ac.uk 
-------------------------------------------------------------------------------

On Tue, 1 Jun 1999 lasteyrie@iname.com wrote:

> 	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
> 
>