[Zope] Extending ZSQL methods to zope objects

[Chuck Burdick (TT)]

Does anyone have some simple (and useful) examples in which the results from
ZSQL methods are extended to be zope objects?  

I'm trying to figure out what is possible and what is not.  Right now, the
documentation in the ZSQL guide gives a trivial example of an extension.
However, the guide only eludes to tying together ZSQL results with a URL
(ex: http://some.zope/myfolder/myzsql/lastname/Smith) and does not really
explain how this works.

I would love to see some more realistic examples of using ZSQL methods in a
powerful way.  Can you use the URL to define searches and filters based on
ZSQL results and inherit the index_html from a base folder?  What else is
possible?

It seems that simple-yet-powerful integration of Zope with SQL datasources
is crucial to Zope's success.  Maybe DC can enlighten us on some ZSQL best
practices.

Thanks in advance,
Chuck Burdick
Web Administrator / Developer
Trading Technologies, Inc.

chuck.burdick@tradingtechnologies.com
(847) 424-8844