Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re: DBI::rows

by LD2 (Curate)
on Jun 29, 2001 at 00:47 UTC ( [id://92459]=note: print w/replies, xml ) Need Help??


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

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://92459]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (5)
As of 2024-04-24 19:08 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found