Problem with count

[snowboardr]

I am trying to do a count in my ASP application and I am able to do this on a few:

This returns 16, and there are 16 records that mactch this criteria.

SELECT count(*) as UserCount,ureadstatus FROM users WHERE ureadstatus = 0 GROUP by ureadstatus

But when I do this it returns 1, and it should return 5 (> is the change)

SELECT count(*) as UserCount,ureadstatus FROM users WHERE ureadstatus > 0 GROUP by ureadstatus

When I do this select in MySQLfront (a gui program for mysql) it returns 5 rows with 1 in each row...


Regards,

Jason

 

[r937]

if it works in mysql-front (great app, i use it too) then this sounds like a problem for the asp forum

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts May 8 2005)

 

[snowboardr]

I figured it out, it was the group by was not required for this... Yes MySQL front is great I have used it for years.

Site San Diego www.sitesd.com