Some, e.g. to fetch the last inserted id of a record, because every database is different there.
-Alex > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:dbix-class- > [EMAIL PROTECTED] On Behalf Of Thomas Hartman > Sent: Thursday, July 13, 2006 2:21 PM > To: [email protected] > Subject: Re: [Dbix-class] select from dual > > DBIC doesn't have any vender specific (eg, oracle specific) code, does > it? > > Or does it? > > Thomas. > > 2006/7/12, Hartmaier Alexander <[EMAIL PROTECTED]>: > > > > > > > > > > Hi! > > > > > > > > If you grep through the dbic sources you can see that dbic uses raw > sql to > > do that, for example to the get last inserted id in Oracle: > > > > > > > > my $sql = "SELECT " . $seq . ".currval FROM DUAL"; > > > > my ($id) = $self->_dbh->selectrow_array($sql); > > > > > > > > @mst: how much performance impact does the use of '' instead of "" > have? > > > > > > > > > > > > > > > > > > -Alex > > > > > > > > > > ________________________________ > > > > > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of > > mark davies > > Sent: Tuesday, July 11, 2006 5:56 PM > > To: [email protected] > > Subject: [Dbix-class] select from dual > > > > > > > > > > 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 > > > *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*" > *"*"* > > T-Systems Austria GesmbH Rennweg 97-99, 1030 Wien > > Handelsgericht Wien, FN 79340b > > > *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*" > *"*"* > > Notice: This e-mail contains information that is confidential and may > be > > privileged. > > If you are not the intended recipient, please notify the sender and > then > > delete this e-mail immediately. > > > *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*" > *"*"* > > _______________________________________________ > > 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/dbix- > [EMAIL PROTECTED]/ *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* T-Systems Austria GesmbH Rennweg 97-99, 1030 Wien Handelsgericht Wien, FN 79340b *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* Notice: This e-mail contains information that is confidential and may be privileged. If you are not the intended recipient, please notify the sender and then delete this e-mail immediately. *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* _______________________________________________ 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]/
