Re: retrieve many values

From: Ing. Branislav Gerzo (2ge_at_2ge.us)
Date: 02/22/05 

Date: Tue, 22 Feb 2005 16:50:17 +0100
To: DBI-Users <dbi-users@perl.org>

Scott T. Hildreth [STH], on Tuesday, February 22, 2005 at 08:50
(-0600) typed the following:

STH> my $sth = $dbh->prepare("QUERY");
STH> $sth->{"mysql_use_result"} = 1;

this is indeed nice, but solve problem only half. When I "process"
value I want insert/update it to db. But I get, when calling
update/insert statement this error:
Commands out of sync; you can't run this command now
I google it and at
http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/Commands_out_of_sync.html
is explanation

So, now I connect to db via 2 handles, in 1 handle I read rows, and
in second I update them. It's not the best solution, but I don't know
how to do that via 1 connect. But thanks anyway! It works now... 

-- 
 ...m8s, cu l8r, Brano.
[Pentium conforms to the IEEE standards - Aaaaaaaiiiiiiiiieeeeeeeeeeeee]