[Dbix-class] quote_char, order_by and DESC

Matt S Trout dbix-class at trout.me.uk
Thu Oct 18 18:55:43 GMT 2007


On Thu, Oct 18, 2007 at 04:39:54PM +0200, Adam Sjøgren wrote:
>   Hi.
> 
> 
> I am accessing a database that may have reserved sql-words as
> schema/table/field-names, with DBIx::Class 0.08007, SQL::Abstract 1.21.
> 
> To have the names quoted, I go:
> 
>   $schema->storage->sql_maker->quote_char('"');
>   $schema->storage->sql_maker->name_sep('.');
> 
> This works fine until a search needs to be ordered descending; passing
> order_by=>'name DESC' results in:

\'name DESC'

-- 
      Matt S Trout       Need help with your Catalyst or DBIx::Class project?
   Technical Director                    http://www.shadowcat.co.uk/catalyst/
 Shadowcat Systems Ltd.  Want a managed development or deployment platform?
http://chainsawblues.vox.com/            http://www.shadowcat.co.uk/servers/



More information about the DBIx-Class mailing list