Re: Counting rows returned from a SELECT with perl DBI.

[Vivek Khera]

>>>>> "BS" == Brian Seitz <bds215@stripped> writes:

BS> Oh, sorry.  I forgot to mention that my SELECT statement has about five
BS> WHERE conditions in it, so I know that COUNT(*) doesn't work. 
BS> Basically, I suppose I'm asking how can I get the same functionality of
BS> COUNT that works with WHERE conditions?

You're looking for the COUNT(*) function.  But you already found it,
just aren't using it.  What makes you think COUNT(*) won't work with a
WHERE clause?

I'd recommend going out and getting a good book on SQL if you're not
sure of these things.


								v.

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@stripped       Rockville, MD       [phone]
PGP & MIME spoken here            http://www.kciLink.com/home/khera/