[Dbix-class] select from dual

[mark davies]

 Hi,

The reason for selecting from dual was to set up a number of environmental
definitions required by the software i am using (MDL- chemical structure
search). I tried setting up a dual class, however this did not work as it
aliased the table name to me, which oracle did not like. The solution was to
use raw sql.

Mark

On 16/07/06, Jess Robinson <castaway at desert-island.demon.co.uk> wrote:
>
>
>
> On Tue, 11 Jul 2006, mark davies wrote:
>
> > Hi,
> >
> > I am new to dbix::class. I am using an oracle database and need to
> select
> > from dual in order to initialise an environment. What is the correct way
> to
> > select from dual using dbix::class?
> >
> > Mark
>
> There isn't a built-in way to do that, currently, you could make a dummy
> "dual" class..
>
> What did you need it for?
>
> Jess
>
>
> _______________________________________________
> List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
> Wiki: http://dbix-class.shadowcatsystems.co.uk/
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
> Searchable Archive:
> http://www.mail-archive.com/dbix-class@lists.rawmode.org/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.rawmode.org/pipermail/dbix-class/attachments/20060717/31c2bb84/attachment.htm