Am 09.03.2009 um 20:06 schrieb fREW Schmidt:
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
.
_______________________________________________
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
