[Zope] Not grocking RESQUEST.set syntax

[Ender]

Noah wrote:
> 
> I'm still not grocking the syntax for setting REQUEST fields.
> I want to set a REQUEST field "filename" to be the value returned
> by a ZSQL call. I want something like this (pseudo-code of what I want):
> 
> <dtml-let FOO=MyFavoiteZSQLMethod>
> <dtml-call "REQUEST.set('filename', FOO)">
> <dtml-call some_other_thing_that_uses_filename>
> </dtml-let>
> 
> That does not work because FOO gets set to something like:
> <Shared.DC.ZRDB.Results.Results instance at 7760b0>
> I tried sticking this inside <dtml-in><dtml-in> to get
> at the sequence-item, but I just ended up getting confused.

thats because you're working on the results returned by a zsql method
which is a result object, you want access to values within it.

try

<dtml-call "REQUEST.set('filenames',
MyFavoriteZSQLMethod(REQUEST).dictionaries())">


this returns the list of dictionaries that represent rows in the table,
with column names as keys and column values as values.

you can reference
lib/python/Shared/DC/ZRDB/Results.py
for more info on the results object


kapil