[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