[Catalyst] Sort - ORDER BY

Matt S Trout dbix-class at trout.me.uk
Tue Nov 8 21:57:05 CET 2005


On Tue, Nov 08, 2005 at 12:43:43PM -0800, Will Smith wrote:
> thanks Matt, I've tried that, but this is what i've got:
>  
> [Tue Nov  8 15:35:10 2005] [catalyst] [error] Caught exception "DBD::SQLite::db
> prepare_cached failed: near "
> ": syntax error(1) at dbdimp.c line 268 [for Statement "SELECT artistid
> FROM   artist
> WHERE
> "] at C:/Perl/site/lib/Ima/DBI.pm line 391."

Sorry, gave you the DBIx::Class syntax. Try { 1 => 1 } instead of { }.

Better still, try reading the Class::DBI and Sweet docs, the Class::DBI
wiki, and asking Class::DBI questions on the Class::DBI mailing list (I'm
on that one too ...)

-- 
     Matt S Trout       Specialists in Perl consulting, web development, and
  Technical Director    UNIX/Linux systems architecture and automation. Mail
Shadowcat Systems Ltd.  mst (at) shadowcatsystems.co.uk for more information

 + Help us build a better perl ORM: http://dbix-class.shadowcatsystems.co.uk/ +



More information about the Catalyst mailing list