Basic SQL Select displays No records

[Javamahn]

Can someone tell me what is wrong with this statement?

SELECT Category, Count(*) as Cat_tot
FROM spam_audit_log group By Category
ORDER BY Cat_tot Desc

It collects from a mySQL database. If I execute this in mySQL-Front it gives me the records I need. If I use the same statement as a VBscript ASP page I get no data. It seems like a straight forward basic statement.

 

[lebisol]

SELECT *
select all
SELECT some,some2,filed3

--> Count(*)

> need more info?
:: don't click HERE ::

 

[martiros]

Yes,it is a straight forward basic statement
How about this?

SELECT Category, Count(*)
FROM spam_audit_log
GROUP By Category
ORDER BY real_column_name

If this also will not work - delete ORDER BY line and try.

 

[martiros]

Another thought.

SELECT Category, Count(*)
FROM spam_audit_log
GROUP By Category
ORDER BY Count(*)DESC

My bet - it will not work because of (*) in ORDER BY Count(*)DESC

So, I'd try:

SELECT Category, Count(id)
FROM spam_audit_log
GROUP By Category
ORDER BY Count(id)DESC;

id - your autoNum column & can't have null values

 

[lebisol]

...as I typed....perhaps I need to put more words to my "-->" part ...LOL

> need more info?
:: don't click HERE ::