How To Use On Duplicate Key Update In MySQL

Author: , May 16th, 2011

How To Use DBIx::SQLEngine To Get A Count

Author: , May 11th, 2011

How To Get a Count of Distinct Items in SQL

Author: , August 3rd, 2010

[code]SELECT city, sum(is_special) as special_count FROM stores where state="$state" group by city[/code]

Sometimes even CPAN modules have issues

Author: , January 5th, 2010

Found that DBIx::Wrapper was BROKEN BADLY – now using DBIx::SQLEngine with great success… Just had our first successful test from the database through JSON to the javascript front-end. Very nice. Zooooooooom!