The following is my DTML code, purposely to valid
the entry field and return the right sql Searching method according to the
situation:-
<dtml-if "_['<dtml-var custname>']!="""
AND "_['<dtml-var custid>']==""">
<dtml-in
sqlSearchcust3>
#// if the custid is blank and custname is not blank then will use sqlSearch3 <dtml-elif "_['<dtml-var custid>']!=""" AND "_['<dtml-var custname>']=="""> <dtml-in
sqlSearchcust2>
#// if the custid is not blank and
custname is blank then will use sqlSearch2
<dtml-elif "_['<dtml-var custid>']=="""
AND "_['<dtml-var
custname>']==""">
<dtml-in sqlSearchcust> #// if the custname is not blank and custid is not blank then will use sqlSearch <dtml-else>
<dtml-var
expr="REQUEST['/Customer/View/searchallcust']">
#// if the
custname is blank and custid is blank then will go to view a list
of customer record.
</dtml-if>
The following is the ZOPE error:-
Unexpected tag, for tag <dtml-elif
"_['<dtml-var custid>']==""" AND "_['<dtml-var custname>']!=""">,
on line 9 of a
For my sql method syntax are as
follow:-
1.sqlSearchcust3
select *
from customer <dtml-sqlgroup where> <dtml-sqltest custid op=ne type=string> <dtml-and> <dtml-sqltest custname op=like'%%' type=string> </dtml-sqlgroup> 2. sqlSearchcust2
select *
from customer <dtml-sqlgroup where> <dtml-sqltest custid op=eq type=string> <dtml-and> <dtml-sqltest custname op=ne type=string> </dtml-sqlgroup> 3. sqlSearchcust
select *
from customer <dtml-sqlgroup where> <dtml-sqltest custid op=eq type=string> <dtml-and> <dtml-sqltest custname op=like'%%' type=string> </dtml-sqlgroup> This is urgent! Please give me some solution,
Thanks! |