At 10:04 AM -0300 6/19/01, Paulino Michelazzo wrote:
>Hi all!
>
>I need to get the "count" field in a select instruction like this:
>
>(from My-SQL help)
>
>SELECT owner, COUNT(*) FROM pet GROUP BY owner
>+--------+----------+
>| owner | COUNT(*) |
>+--------+----------+
>| Benny | 2 |
>| Diane | 2 |
>| Gwen | 3 |
>| Harold | 2 |
>+--------+----------+
>
>I use Cold Fusion with My-SQL and i can get the owner field easy,
>but the count field IS NOT a really field
It isn't? Why is that?
>
>Anybody can help me?
>
>Thanks a lot4
>************************************************************
>Paulino Michelazzo - IT Adviser
>http://www.michelazzo.com.br
>paulino@stripped - ICQ: 2911392
>BOX 31210 - SP/SP - CP: 01309-970 - Brazil/SA
--
Paul DuBois, paul@stripped
