Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re^2: fetchrow_array loop in perl 5.10

by bulrush (Scribe)
on Sep 18, 2014 at 19:33 UTC ( [id://1101106]=note: print w/replies, xml ) Need Help??


in reply to Re: fetchrow_array loop in perl 5.10
in thread fetchrow_array loop in perl 5.10

Depending on (the version of) your database driver, it might be that your database driver does not like more than one statement handle being active at the same time.

Yep, that's what happened to me. I had to declare $dbh2 to make my stuff work. $dbh cannot handle both statements. I use DBD::Pg for Postgresql.

Perl 5.8.8 on Redhat Linux RHEL 5.5.56 (64-bit)

Replies are listed 'Best First'.
Re^3: fetchrow_array loop in perl 5.10
by erix (Prior) on Sep 18, 2014 at 19:54 UTC

    See perhaps, DBI, fork, and clone.

    I can't tell if applicable to those problems (yours and that of the OP), but it's interesting anyway :)

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1101106]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others learning in the Monastery: (8)
As of 2024-04-19 09:02 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found