[Dbix-class] order by field?

Hi, In MySQL is possible to do something like: select * from table_name order by field(department, 'Marketing', 'Sales', 'Financial', 'IT', 'Operations'); In other databases it should be done differently Is it possible to do this search with DBIC? --Octavian

Re: [Dbix-class] order by field?

I am doing such a order with the following SQL: ... ORDER BY (department = 'Marketing') DESC, (department = 'Sales') DESC, (department = 'Financial') DESC, (department = 'IT') DESC, (department = 'Operations') DESC, ... But there is no special way to use this with DBIx::Class :-/

Re: [Dbix-class] exception_action fail after DBIC upgrade

On Mon, Dec 10, 2012 at 1:09 AM, Peter Rabbitson wrote: > On Mon, Dec 10, 2012 at 12:30:52PM +0400, Konstantin A. Pustovalov wrote: > > Hello list! > > > > I'm using exception_action feature. Some of my tests fail after > > upgrading 0.08196 -> 0.08204 > > I have reduced test case to the followin

[Dbix-class] d...@amerimerchant.com

Thanks and Regards, DongHo Kim Senior Developer AmeriMerchant 475 Park Avenue South 16th Floor New York, NY 10016 Tel: 212-779-2100 x148 http://www.amerimerchant.com Description: cid:part2.02090202.09080209@amerimer

[Dbix-class] Query is NOT created successfully.

Hello, When I use DBIx::Class::ResultSet::search() method with a complex query with multiple joins, the query produced from DBIx::Class is not complete. Some conditions are missing in the SQL query when I check the SQL. If I test it with each condition separately, then SQL is OK with that conditi