Re: DBI does not do what I expect...

On Mar 12, 3:48 am, Frank Seitz <devnull4...@xxxxxx> wrote:
Mark Jaffe wrote:

But when I execute the SQL, I only get "1" returned for each "$rows",
rather than what I expect, the number of rows.

Why is this not working for me?

"SELECT COUNT(*) ..." returns one row, which is the number
of counted rows.

Frank
--
Dipl.-Inform. Frank Seitz;http://www.fseitz.de/
Anwendungen für Ihr Internet und Intranet
Tel: 04103/180301; Fax: -02; Industriestr. 31, 22880 Wedel

Exactly. So, not to put too fine a point on it what Mark wanted to do
was something like:

"SELECT COUNT(*) Cnt..."
...
my $srcHref = $sth->fetchrow_hashref();
print $srcHref->{Cnt};

# QED


.