Hello,
I want to update many Rows with the same sequence-number.
My solution is :
$sql = "SELECT my_seq.nextval FROM DUAL";
($id) = $storage->_dbh->selectrow_array($sql);
$resultset->update({ 'nr' => \'my_seq.currval'});
or
$resultset->update({ 'nr' => $id });
Can I do it better?
Regards
Dieter
--
FastJack
Psssst! Schon vom neuen GMX MultiMessenger gehört?
Der kanns mit allen: http://www.gmx.net/de/go/multimessenger
_______________________________________________
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]/
