Just wanted to chime in and mention that I'm using this as well. I prefer the Rose way of building queries to other modules that I have used in the past, such as SQL::Abstract.
Any chance of getting support for HAVING to go along with GROUP BY? Cheers, On 3/27/07, John Siracusa <[EMAIL PROTECTED]> wrote: > On 3/27/07, Robert James Kaes <[EMAIL PROTECTED]> wrote: > > My reading of the Rose::DB::Object::QueryBuilder documentation is that > > build_select() does NOT support the "offset" argument like the > > get_objects() manager method. Is this an oversight, or is there a > > fundamental reason why build_select() does not support offset (but does > > support limit?) > > As the Manager has gained features, I haven't been updating the public > QueryBuilder interface. QueryBuilder was always meant as an internal > tool first (used by Manager) that just happens to expose a subset of > its functionality publicly. The QueryBuilder API is so unwieldy that > I doubted many people would actually use it, but apparently a few > people do. > > Anyway, in this case, the db-specific limit smarts are all in Manager > (and in private Rose::DB APIs). QueryBuilder's public API doesn't > handle offset, and will handle limits incorrectly for databases that > need something beyond the simple "LIMIT ..." syntax. But since it is > so simple-minded, you can probably get away with stuff like "limit => > '100,20'" or "limit => '10 OFFSET 5". > > -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 > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/rose-db-object > ------------------------------------------------------------------------- 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 [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/rose-db-object
