I was wondering if it was possible to use 'group' as a field name in MySQL.
I know, pretty dumb and should be avoided unless you're looking for trouble.
Anyway, I was looking at post 2847 regarding quoting fields
http://www.mail-archive.com/[email protected]/msg02847.html
and tried a couple of things out.
I found that using connection info quote_char like this in my model class:
use base qw/DBIx::Class::Schema::Loader/;
...
__PACKAGE__->loader_options(
relationships => 1,
);
__PACKAGE__->connection($dsn, $user, $pass, { quote_char => '`' });
Gave me SQL on table "user" like this:
DBIx::Class::ResultSet::find(): Error executing 'SELECT `me.id`, `me.login`,
`me.password`, `me.group`, `me.salutation`, `me.forename`, `me.initials`,
`me.surname`, `me.name`, `me.email`, `me.tel`, `me.fax`, `me.mobile`,
`me.account_status` FROM `user` `me` WHERE ( ( `me.login` = ? ) )': Unknown
column 'me.id' in 'field list'
This gives an error in MySQL because it expects `me`.`id` not `me.id`.
http://dev.mysql.com/doc/refman/4.1/en/identifier-qualifiers.html
"If any components of a multiple-part name require quoting, quote them
individually rather than quoting the name as a whole. For example, write
`my-table`.`my-column`, not `my-table.my-column`."
Is this style common across other databases? If so I could send in a patch
to handle it.
Regards, Peter
www.dragonstaff.com
_______________________________________________
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]/
