PDA

View Full Version : COUNT and GROUP BY returns 0 records through mySQL ODBC

dunsap
02-07-02, 01:07
when i run the query:

select count(url) as count, url
from emailtracking
group by url
order by count desc;

in mySQL.exe I get no problems and get the corresponding recorsds. when i run it from ASP, i get 0 records. i've seen the problem before here: http://devrandom.net/lists/archives/2001/5/MySQL/2327.html but no resolution.

any idea how to fix/work around?

thanks,

dunsap.
nigelrivett
02-17-02, 23:46
Can't get to the url posted.
Probably doesn't make a difference but it is never a good idea to use a keyword as an identifier so you might change count to urlCount or something.