http://qs321.pair.com?node_id=92459


in reply to DBI::rows

How about "SELECT COUNT(*) as Count FROM people WHERE l_name LIKE 'B%'"?

That should work fine..

Replies are listed 'Best First'.
Re:x2 DBI::rows
by grinder (Bishop) on Jun 29, 2001 at 12:04 UTC

    In fact, if you use Sybase, that is the only of counting the number of rows. In essence, the only way the Sybase engine can tell you how many rows would be returned by a select is to go and fetch them.


    --
    g r i n d e r
[reply]

In Section Seekers of Perl Wisdom