[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