[Dbix-class] bad column names?

Moritz Onken onken at houseofdesign.de
Mon Mar 9 19:18:56 GMT 2009


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 
.




More information about the DBIx-Class mailing list