[Zope] how call a ZSQL method from a product instance+work w the results

[Christian Theune]

Hi.

See zopelabs.com for the article of generically calling objects/functions
in zope (by casey duncan).

Then simply acquire the query and call it. The resultset is easy handable
when using 

result = .... call the query here ...().dictionaries() which will
give you a list of dictionaries.


* hans <hans@beehive.de> [020312 17:00]:
> inside my product i have a method like
> 
>  def manage_draw_PI(self, REQUEST=None):
>   """draw:
>       get the x- and y-coords from database
>   """
>   self.sql_method = \
>   sql_method = self.aq_parent['sql_query']     # aquired from container
> 
>   self.sql_result = sql_method.__call__(query=self.sql_query) # query =
> 'select * from PI'
>   self._p_changed = 1
>   if REQUEST is not None:
>    management_view='Edit' # tell zope to hilight mgnt tab
>    return self.manage_edit_PraxisIndex_Form(self)
>   else:
>    return
> 

> (hey, what is a zbrain and what is it good for?)

dunno, i never cared for that and it simply doesn't disturb you. :)


Greetings

Christian

-- 
Christian Theune - ct@gocept.com
gocept gmbh & co.kg - schalaunische strasse 6 - 06366 koethen/anhalt
tel.+49 3496 3099112 - fax.+49 3496 3099118 mob. - 0178 48 33 981

reduce(lambda x,y:x+y,[chr(ord(x)^42) for x in 'zS^BED\nX_FOY\x0b'])