On 27/01/2008, Jonathan Rockway <[EMAIL PROTECTED]> wrote: > "Aaron Trevena" <[EMAIL PROTECTED]> writes: > > > On 25/01/2008, Jonathan Rockway <[EMAIL PROTECTED]> wrote: > > Can you do that with subsets of a result set - i.e. I have a resultset > > of a page of records, 20 need to have the "fantastic" flag set, 100 > > need to have the state set from "pending" to approved. > > Well, one resultset should contain the records that need to be > "fantastic", and another should contain the records that need to be > approved. Then you update them as appropriate.
What about slices of resultsets - can't I fetch my 100 objects then put 30 in on resultset, 90 in another and 40 in yet another without hitting the database 4 times instead of 3 ? I did this in my subclass of CDBIs Iterator and it would be especially handy in this situation. A. -- http://www.aarontrevena.co.uk LAMP System Integration, Development and Hosting _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[EMAIL PROTECTED]
