Marc Espie wrote:
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... ?
Mainly because no one has got around to writing it yet. Its been on my
todo list for about two months, more important things keep getting in
the way.
Ash
_______________________________________________
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]/
