sqlgroup-if-and-else-or dilemma
Hi all, I'm trying to construct a search interface which allows users to build a set of search conditions against a large DB view. One of the requirements for this is that the users be able to choose between AND and OR operators for each condition. Something like (silly example...): Country = Japan and Area = Tokyo or Area = Kyushu These conditions are converted to a where statement using DTML. The problem is that Zope (still 1.10.3 :^( complains about unexpected <!--#and--> and <!--#or--> tags within <!--#if--> blocks. For example: <!--#sqlgroup where--> ... generated conditions ... <!--#if "LogOp=='AND'"--> <!--#and--> <!--#else--> <!--#or--> <!--#/if--> ... Another condition ... <!--#/sqlgroup--> doesn't work. I guess the Zope internals weren't meant to handle this construct. Has anyone been here before? Any ideas? Any suggestions would be greatly appreciated. Happy Zopeing! John Jarvis
participants (1)
-
TFE MMS JARVIS JOHN