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 <
[EMAIL PROTECTED]> 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/[email protected]/
_______________________________________________ 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/[email protected]/
