in reply to Re: Re: DBD::CSV and SQL::Statement
in thread DBD::CSV and SQL::Statement

Also, does DBD::RAM support row counts such as:

select count(*) from table where id = '$id' group by type_name

Thanks.
  • Comment on Re: Re: Re: DBD::CSV and SQL::Statement

Replies are listed 'Best First'.
Re: Re: Re: Re: DBD::CSV and SQL::Statement
by jZed (Prior) on Mar 29, 2001 at 07:55 UTC
    Sorry, no count or group by yet.

    But $sth->rows gives a count even without a fetch. So:

    my $sth=$dbh->prepare(qq{SELECT * FROM foo WHERE bar = baz})
    $sth->execute;
    print $sth->rows, "matched the query";