On Mon, Mar 9, 2009 at 5:24 PM, fREW Schmidt <[email protected]> wrote:
> Hi all! >>> >>> We are dealing with some weird issues because our database has silly >>> column names. Specifically speaking we have a column called 'user'. user >>> is a reserved word in T-SQL (we are using SQL Server.) Anyway, this is the >>> error we get: >>> >>> DBIx::Class::ResultSet::find(): Error executing 'SELECT me.user, >>> me.password, me.site, me.image, me.ro FROM Users me WHERE ( me.user = ? >>> )': [Microsoft][SQL Native Client][SQL Server]Incorrect syntax near the >>> keyword 'user'. (SQL-42000) >>> >>> Is there a standard way around this? >>> >>> Thanks! >>> >> >> There is: >> >> >> http://search.cpan.org/~ribasushi/DBIx-Class-0.08012/lib/DBIx/Class/Manual/Cookbook.pod#Setting_quoting_for_the_generated_SQL<http://search.cpan.org/%7Eribasushi/DBIx-Class-0.08012/lib/DBIx/Class/Manual/Cookbook.pod#Setting_quoting_for_the_generated_SQL> >> . > > > I actually couldn't get either of these solutions to work. I asked for > help on the IRC Channel and I got this far: > > use lib '/Inetpub/wwwroot/cgi'; > > use My::Schema; > > use strict; > > >> my $schema = My::Schema->connect("dbi:ODBC:DSN=LynxSQL", > > "Test_Lornx","Password1!", { > > quote_char => [qw/[ ]/], > > name_sep => '.', > > limit_dialect => 'mssql', > > }); > > >> my $parent = $schema->resultset('LogParent')->find(62); > > print $parent->subject; > > >> my @equip = $schema->resultset('User')->find('test')->equipment; > > print $equip[0]->serialnumber; > > > But it still acts like I never set any of those settings and I get the same > error: > > DBIx::Class::ResultSet::find(): Error executing 'SELECT me.user, >> me.password, me.site, me.image, me.ro FROM Users me WHERE ( me.user = ? >> )': [Microsoft][SQL Native Client][SQL Server]Incorrect syntax near the >> keyword 'user'. (SQL-42000) > > > Anyone see what I am missing? > We figured it out. Our ancient repos (activestate) only had up to version .06000 and we had issues updating. After that everything worked. -- fREW Schmidt http://blog.afoolishmanifesto.com
_______________________________________________ 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/[email protected]
