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 :andyjarrett.co.uk/downloads/stats-mysql-friendly.zip
comments powered by Disqus