[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