BlogCFC, stats.cfm and MySQL

Just been playing around with Rays new Blog Stats, which is pretty sweet, if you haven't got it all ready I recommend downloading it now. Anyway to get it working with MySQL i had to make a couple of small changes. Namely just changing the "ORDER BY" line to use the alias and not count(col_name) and remove TOP 10 and replaced with LIMIT 10. If you want to use my edited MySQL friendly version of his code you can get it at
comments powered by Disqus