|
|
sybperl-l Archive
Up Prev Next
From: "Larry Martell" <larrym at titan dot imsi dot com>
Subject: Re: Can't get rid of "pending results"
Date: Nov 1 1997 12:39AM
It could be that $select4 returns multiple result sets, and you need
to call dbresults again. Run that query in isql and see what you get back.
HTH,
larry
On Oct 31, 18:34, John Gilmore-Baldwin wrote:
> Subject: Can't get rid of "pending results"
> I've run into a problem that really has me stumped. At a certain point in
> my query, I get the following error:
>
> DB-Library error:
> Attempt to initiate a new SQL Server operation with results pending.
> Processing text:
>
> OK, I figured. I'll just grab and throw away the results everywhere and
> all will be well. Well, no cigar on that idea.
>
> I narrowed the problem down to a single statement. basically, it goes like
> this:
>
> $dbHandle->dbcmdn($select4);
> $dbHandle->dbsqlexec;
> $dbHandle->dbresults;
> while (@data = $dbHandle->dbnextrow) { print "."; };
> $dbHandle->dbcmdn($select5);
> $dbHandle->dbsqlexec;
> $dbHandle->dbresults;
> while (@data = $dbHandle->dbnextrow) { };
>
> I get the error trying to process $select5.
|
