[Dbix-class] Oracle Column Quoting
Jose Fonseca
zefonseca at gmail.com
Wed Feb 13 20:20:10 GMT 2008
Hope that helps!
Cheers, Ze
On Feb 13, 2008 5:58 PM, Steve Kirkup <skirkup at jupiterimages.com> wrote:
> Howdy,
>
>
> I have a rather unique problem and I am unsure of how to fix this. I
> am connecting to Oracle, one of the tables I HAVE to work with is using
> a keyword as the column name (I didn't do it!).
>
> The way to get select statements to work is by single-quoting the
> column call. Example:
>
> SELECT
> 'me.level'
> FROM
> test me;
>
> The problem is that DBIx::Class does not do the single quoting by
> default and the single-quoting behavior, I don't believe, does not work
> for all databases.
>
> Does anyone have suggestions about how this problem could be addressed?
>
> Steve Kirkup
>
> _______________________________________________
> 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.rawmode.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20080213/2c7=
b56d9/attachment.htm
More information about the DBIx-Class
mailing list