Hi,<br>
<br>
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.<br>
<br>
Mark<br><br><div><span class="gmail_quote">On 16/07/06, <b class="gmail_sendername">Jess Robinson</b> <<a href="mailto:castaway@desert-island.demon.co.uk" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
castaway@desert-island.demon.co.uk</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br><br>On Tue, 11 Jul 2006, mark davies wrote:<br><br>> Hi,<br>><br>> I am new to dbix::class. I am using an oracle database and need to select<br>> from dual in order to initialise an environment. What is the correct way to
<br>> select from dual using dbix::class?<br>><br>> Mark<br><br>There isn't a built-in way to do that, currently, you could make a dummy<br>"dual" class..<br><br>What did you need it for?<br><br>Jess<br>
<br><br>_______________________________________________<br>List: <a href="http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
</a><br>Wiki: <a href="http://dbix-class.shadowcatsystems.co.uk/" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://dbix-class.shadowcatsystems.co.uk/</a><br>IRC: irc.perl.org#dbix-class<br>SVN: <a href="http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/</a><br>Searchable Archive:
<a href="http://www.mail-archive.com/dbix-class@lists.rawmode.org/" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.mail-archive.com/dbix-class@lists.rawmode.org/</a><br></blockquote></div>
<br>