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> How about checking the database table for foo rather than the result set:
ZSQL method name=select argument=foo select foo_col from table where foo_col =<dtml-sqlvar foo type="string"> then do: <dtml-in select> <dtml-call "REQUEST.set('z','t')">
<dtml-else> <dtml-call "REQUEST.set('z','f')"> </dtml-in>
If the variable is in table then dtml-in returns a result set and the <dtml-call "REQUEST.set('z','t')"> is called, if not the dtml-else is called. HTH Regards Garry