[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 16:22:45 GMT 2013


Paul,

thanks a lot. after following your instruction,
it works good now
I found every table, every collum has been quoted with [ ]
so, it works good now

Hugh Wang

Paul Findlay 写道:
> Hi Hugh
>
> You seem to be putting quote_char and name_sep into their own hash ref. You should have them directly in the connect_info hash ref:
>
>     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{.},
>     }
>
> Kind regards,
>
> Paul Findlay
>
>
>
> DISCLAIMER
> This email contains information that is confidential and which may be legally privileged. If you have received this email in error, please notify the sender immediately and delete the email. This email is intended solely for the use of the intended recipient and you may not use or disclose this email in any way.
>
> _______________________________________________
> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
>
>   





More information about the DBIx-Class mailing list