Hi, i wrote a simple personal training diary, actually i convert my perl CGI DBI script to Catalyst DBIx::Class.
what is the best way to convert sql querys like this: SELECT YEAR( datum ) jahr, SUM( km ) summe_km, COUNT( km ) anzahl, SUM( time_to_sec( dauer ) ) summe_dauer, SUM( hm ) summe_hm FROM data WHERE 1 GROUP BY jahr'; i it possible without literal sql ? _______________________________________________ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class Wiki: http://dbix-class.shadowcatsystems.co.uk/ IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/ Searchable Archive: http://www.mail-archive.com/[email protected]/
