On 12/3/06 5:13 PM, Mike Schilli wrote: > By the way, this might be a stretch, but what I would really want is a > query like > > SELECT MAX(event_time), some_val > FROM some_table > WHERE event_time > "2006-12-03 08:39:00" > GROUP BY some_val; > > that would give me only the *newest* some_val. Is there a way to > tell that to the manager?
That'd be another use for the still-to-come get_results() Manager method. In the meantime, there are a few alternative approaches. See this old mailing list post for more information and examples: http://www.mail-archive.com/rose-db-object@lists.sourceforge.net/msg00947.ht ml The sf.net mail archive seems to be down, and that mail archive seems to think some perl variables are email addresses, replacing them with "[EMAIL PROTECTED]". The GMANE archive has similar issues, but mangles in a different way: http://permalink.gmane.org/gmane.comp.lang.perl.modules.dbi.rose-db-object/9 46 Ah well... -John ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
