Re: [Dbix-class] How do I get DBIx::Class to quote User table and user collum in SQL Server ?

[Hugh Wang]

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

   



___
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

RE: [Dbix-class] How do I get DBIx::Class to quote User table and user collum in SQL Server ?

[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