Angie asked:

The problems is i'm not sure my dtml in order to control the loop of choosing the correct sql in the right situation. The following is my DTML:-

<dtml-if "_["<dtml-var custid>"]==custid","_["<dtml-var custname>"]==custname"> <dtml-in sqlSearchcust1> </dtml-if>

<dtml-elif "_[""]==custid","_["<dtml-var custname>"]==custname"> <dtml-in sqlSearchcust2> </dtml-if>

<dtml-elif "_["<dtml-var custid>"]==custid","_[""]==custname"> <dtml-in sqlSearchcust3> </dtml-if>

First, the rule is "No DTML inside DTML", which translates to simply refering to objects by names, in any DTML tag, like so: <dtml-if "_['custid']==custid,_['custname']==custname"> Also, notice that the only Double-Quotes are the outside pair, inside those you must use single quotes. Last, the only DTML-IF tag you need is that final one. Try this much, and see if all your probems go away. If not, let us know. Later, Jery S.