[Zope] dtml-in statement with mysql

[Andreas Jung]

your dtml-nesting is not allowed and not supported.
call the corresponding zsql based on your condition *outside*
dtml-in, assign the result to a variable and *then* use
dtml-in to iterate over the result list.

-aj

--On Freitag, 19. September 2003 11:00 Uhr -0600 Steve Lenti 
<slenti at abqpubco.com> wrote:

> I have a small question.  I have a couple of sql methods defined and
> depending on the search method I want to excute a specific one and
> return the results.  I want to do something like this
>
> <dtml-if expr="search_method == '1'">
>  <dtml-in sql_1>
> <dtml-elif expr="search_method == '2'">
>  <dtml-in sql_2>
> </dtml-if>
> ... the rest of the the results
>
> the problem I have is that zope doesn't like me using dtml-in statements
> inside the if statements unless I copy the whole results page into the
> if statement.  What I want to do is depending on what the search_method
> variable is I want to call a specific sql method without having to put
> all the code in each if statement.  is there anyway to accomplish this.
> hope I have been clear enough.
>
> thanks in advance,
>
> --STEVE
>
> _______________________________________________
> Zope maillist  -  Zope at zope.org
> http://mail.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://mail.zope.org/mailman/listinfo/zope-announce
>  http://mail.zope.org/mailman/listinfo/zope-dev )