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 Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object
