On Sat, 2006-11-11 at 05:21 -0500, Mike Friedman wrote: > The way to get around this is to quote the column names in the SQL > (`group` instead of group). Is there a way to get DBIC to do this?
from DBIx::Class::Storage::DBI POD: quote_char Specifies what characters to use to quote table and column names. If you use this you will want to specify name_sep as well. quote_char expects either a single character, in which case is it is placed on either side of the table/column, or an arrayref of length 2 in which case the table/column name is placed between the elements. For example under MySQL you’d use "quote_char => ’‘’", and user SQL Server you’d use "quote_char => [qw/[ ]/]". name_sep This only needs to be used in conjunction with quote_char, and is used to specify the charecter that seperates elements (schemas, tables, columns) from each other. In most cases this is simply a ".". bogdan _______________________________________________ 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]/
