On 4/13/07, Derek Watson <[EMAIL PROTECTED]> wrote: > 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.
Yikes, QueryBuilder was in no way meant as a general-purpose replacement for SQL::Abstract! :) As I said earlier: > On 3/27/07, John Siracusa <[EMAIL PROTECTED]> wrote: >> QueryBuilder was always meant as an internal tool first (used by Manager) >> that just happens to expose a subset of its functionality publicly. Anyway... > Any chance of getting support for HAVING to go along with GROUP BY? If you throw a group_by arg at it, I believe it will work, although this is undocumented. It's also quite simple-minded, like the limit support, so all it's doing is tacking on a "GROUP BY ..." string with your args shoved in the "..." space. There's nothing for a having clause, although I supposed you could call build_where_clause() and then append the result to the group_by arg with a "HAVING" joiner string. Yuck. Anyway, a much better general-purpose query builder is on my long-term list. Also, there may be other alternatives to SQL::Abstract on CPAN already. I believe Dave Rolsky is working on one, but I don't know if it's released yet. -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
