[Zope] howto sql-query directly from my products methods?

[hans]

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