[Dbix-class] bad column names?

fREW Schmidt frioux at gmail.com
Mon Mar 9 19:06:45 GMT 2009


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 =3D ?
> )': [Microsoft][SQL Native Client][SQL Server]Incorrect syntax near the
> keyword 'user'. (SQL-42000)
>

Is there a standard way around this?

Thanks!
-- =

fREW Schmidt
http://blog.afoolishmanifesto.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20090309/d82=
82e9f/attachment.htm


More information about the DBIx-Class mailing list