Re: retrieve many values

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


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

Scott T. Hildreth [STH], on Tuesday, February 22, 2005 at 08:36
(-0600) thinks about:

STH> Mysql will return all rows by default, you need to turn that off.
STH> I can't remember what the attribute is, read the DBD::mysql perldoc.

I do everything, but I cannot find that. I looked in
http://search.cpan.org/~rudy/DBD-mysql-2.9004/lib/DBD/mysql.pm
and
http://search.cpan.org/~timb/DBI-1.47/DBI.pm

I have in my code in select statement
select ... where ... and mod(a.id+?, 10) = 0

for my $mod (0 .. 9) { ... $sth->execute($mod) ... }
but this really isn't right solution :)

-- 
 ...m8s, cu l8r, Brano.
[Between two evils, I always pick the one I never tried before.]


Relevant Pages