[Zope] Dynamic SQL statement construct

Anthony Baxter Anthony Baxter <anthony@interlink.com.au>
Fri, 30 Jul 1999 16:02:32 +1000


>>> "Miller, John M." wrote
> You might want to check out Anthony Baxter's data miner product at
> http://www.interlink.com.au/anthony/.  Yeah, okay, it may be a 0.1 release,
> but there's plenty of good stuff in there to give you some ideas.

Yep - note that the path to dynamic SQL generation is a slippery one.
You start off pretty simple, and eventually you're writing code to attempt
to detect aggregates in the select clause to differentiate between where and
having, and then things get _real_ ugly.

Anthony
-- 
Anthony Baxter     <anthony@interlink.com.au>   
It's never too late to have a happy childhood.