hans wrote:
well, i could instantiate a bunch of zsql methods, each with its own query and then call them from my products methods. but how could i obviate the need to have these zsql methods and query directly? Or is it just not worth it?
thanks a lot for your answers. the minimal version with just one zsql method i like. but i should have explained more clearly that my queries will be fixed except for the date. Background is, a weekly report should be generated (like CMFArticle, but CMF is too much) including some grafics (statistics), where those grafics derive from queries (generate w PIL). so the queries are fixed (except for date) and the users will never come anywhere near them, security is just some non-issue. secondly, as i understood the zsql-method code, they dynamically aquire their database connectors on each call, ie they are more flexible than my needs, and i thought, i could save on that also. Again: i know the DA (or could aquire at product instantiation), i know the queries and could hard code them in my "render_gif"-methods. If there is a simpler solution than 1 zsql-method w <dtml-var query> im curious. With zope, solutions generally spread fine grained w many objects all over the place and i like to keep things together. still, thanks anyway. -------------------------------------------------------------- hans augustin (software developer) hans@beehive.de beehive elektronische medien GmbH http://www.beehive.de phone: +49 30 847-82 0 fax: +49 30 847-82 299