[CDBI] Please fix CDBI::mysql

Matt S Trout dbix-class at trout.me.uk
Sat May 6 16:49:52 BST 2006


Karjala wrote:
> Is it possible to fix CDBI::mysql so as all field names in SQL 
> statements are surrounded by ` ` ?
> 
> This would allow fields with names like "group" to exist in tables.

Class::DBI uses simple SQL strings that are interpolated with sprintf, 
so it's going to be very hard to do that, I suspect (though I'm hardly 
going to complain if somebody proves me wrong :)

If you want quoting, I'd suggest using DBIx::Class which uses 
SQL::Abstract for SQL generation, and supports this already.




More information about the ClassDBI mailing list