Re: It's a bad day here...

Bruce Johnson <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.general
Message-ID <[email protected]>
Oh man this is embarrassing :-) A sharp-eyed reader pointed out that I was not doing what I thought I was doing!

"I noticed the following (edited for emphasis):

> foreach $i (@resources){
>    $csr_prefapp->execute($i)
>    $csr_prefapp->fetchrow())
>    if (!$have_pref){
>        $csr_allapp->execute($i)
>        $csr_prefapp->fetchrow())
>    }
> }

Shouldn't that last "prefapp" be "allapp" instead?"

Indeed it should, and  with that error corrected, all is well!

The error makes perfect sense now, since I'd already returned all the rows for that cursor.

(and really dumb me, I've seen this very error in the past when I've referenced the wrong cursor....)

-- 
Bruce Johnson

"Wherever you go, there you are" B. Banzai,  PhD
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.