Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Posts
    1

    Unanswered: COUNT and GROUP BY returns 0 records through mySQL ODBC

    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/...ySQL/2327.html but no resolution.

    any idea how to fix/work around?

    thanks,

    dunsap.

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •