On Thu, Dec 07, 2006 at 05:20:36PM +0100, Robert 'phaylon' Sedlacek wrote: > Marc Espie wrote: > > The requests generated by DBIx::Class do not quote field names by default. > > Is there a way to get them quoted ? Even though this generates less readable > > SQL, this can be useful in some cases... > > It's even in the documentation: > http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/Manual/Cookbook.pod#Setting_quoting_for_the_generated_SQL.
Thanks! next question, is there any way to do that automatically ? I come from the old DBI, which often knows about the correct quote chars for the database... I don't quite understand why this is not automatic ? I assume some dbd back-ends might have issues, but in that case, the storage could do stuff correctly on at least common db formats, like sqlite or pg... ? _______________________________________________ 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]/
