Ok, I've added a few more bits to this, and added it to the collector. I'm confused about the change you had to make? was this a bug in my example? Or was it something in your code... Anthony, who really isn't all that good at this documentation thing. (hey, I could go work at digicool ;)

...

...

Graham Chiu wrote In article <200002150501.QAA05051@mbuna.arbhome.com.au>, Anthony Baxter <anthony@interlink.com.au> writes

Thanks. I thought there was something about this on the Zope.org site, but looking under sql or tree failed to find this document.

ah, to heck with it. I'll whack it into the catalog (with big note at the top that it's still incomplete).

Well, your example was a lot easier than the contortions I was going thru before putting conditionals within the sqlquery. It worked well. The only change I had to make to my table was to change the top level parent from a blank to a '0' as Zope didn't like the blank in the conditional.

------- Regards, Graham Chiu gchiu<at>compkarori.co.nz http://www.compkarori.com/dynamo - The Homebuilt Dynamo http://www.compkarori.com/dbase - The dBase bulletin

_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )

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