[Dbix-class] How do I get DBIx::Class to quote User table and user
collum in SQL Server ?
Hugh Wang
yowang at verizon.net
Fri Jun 21 05:10:49 GMT 2013
I am trying to use DBIx Autorization function, I have a table named
User, and collumn named user
since user is a reserved word, it always get error,
I have added the quote_char, name_sep in the connection string
but still fail.
how can I make sure the generated SQL has the User been quoted ?
like select [user] from ...
connect_info => {
dsn => 'dbi:ODBC:driver={SQL Server};server=.....;',
user => '...',
password => .....',
LongTruncOk=>1,
LongReadLen=>5000,
on_connect_do => q{},
{quote_char => [qw/[ ]/],name_sep => q{.} },
}
More information about the DBIx-Class
mailing list