OK, here's a next rev that's close. So I started out saying I have a url-arg value. Let's call that 'key'. And note that foo_col is a boolean field. So now zSql IfShowNextDoor contains SELECT foo_col FROM table where id=<dtml-sqlvar key type=int> And then my DTML uses <dtml-call "REQUEST.set('z',IfShowNextDoor()[0][0])"> (I avoid dtml-let because when you need to do it multiple times, the nesting of the lets gets ugly.) This works (setting value as 0 or 1). (thanks to all for earlier replies: I tried posting this update earlier but it didn't go through somehow) On Nov 28, 2007 1:20 PM, Bill Seitz <fluxent@gmail.com> wrote:
I'm trying to do something in a DTML-Method (in ancient Zope 2.6.2) that seems like it should be really simple, but I can't get it right.
I want to see if a value (defined via url-arg) is in a list which is generated from an RDBMS query (field type=integer).
The pseudo-code would be something like:
if foo in (select foo_col from table where x=y) then z='t' else z='f'
I tried putting the simple SELECT query into a zSql and then calling it like:
<dtml-call "REQUEST.set('foo_list',IfShowNextDoor())"> <dtml-if expr="foo in foo_list"> <dtml-call "REQUEST.set('z','t')"> <dtml-else> <dtml-call "REQUEST.set('z','f')"> </dtml-if>
But that doesn't work.