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