RI Dunfey wrote at 2004-2-16 16:32 +0000:
I have a dtml page which displays the results of a sql query:
<dtml-in expr="my_query(category1=category1, category2=category2)"> <TR><TD> <dtml-var NAME> </TR></TD> </dtml-in>
The values that are passed to the query are obtained from the request object. If the value for category2=None then I want to leave category2 out of the sql query as below:
I suggest you do the logic in a "Script (Python)". It is far easier there. It will look like: request = container.REQUEST category1 = request.get('category1') category2 = request.get('category2') query = { 'category1' : category1 } if category2: # or whatever logic you want query['category2'] = category2 return context.my_query(**query) # here you call your Z SQL Method -- Dieter