[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