This problem troubled me for few weeks, i really
dont know what and where is goin wrong
below is my dtml to display the
Previous record
<dtml-in b previous size=5
start=query_start>
<td ><font
class="next25">
<a
href="<dtml-var URL><dtml-var
sequence-query
>query_start=<dtml-var
previous-sequence-start-number>"
style="text-decoration:none">
Previous <dtml-var previous-sequence-size>
record(s)<<
</a>
</font></td>
</dtml-in>
'b' is my search sql method, because i got 2
searching key so i have to create 3 search sql method to search my record
inorder to select one from these 3 sql methods i used dtml to select
from 3 search sql methods, as follow:
<dtml-with "Search">
<dtml-call
"REQUEST.set('b','')">
*assign a variable 'b'
<dtml-if "_['custname']!='' and
_['custid']==''">
* if custname is not empty and custid is
empty
<dtml-call "REQUEST.set('b',
sqlSearchcust3)">
* assign b as sql method named
'sqlSearchcust3'
<dtml-elif "_['custid']!='' and
_['custname']==''">
* if custid is not empty and custname is
empty
<dtml-call "REQUEST.set('b',
sqlSearchcust2)">
* assign b as sql method named
'sqlSearchcust2'
<dtml-elif "_['custid']!='' and _['custname']!=''">
* if custid is not empty and custname is not empty
<dtml-call
"REQUEST.set('b', sqlSearchcust)">
* assign b as sql method named
'sqlSearchcust'
<dtml-elif "_['custid']=='' and
_['custname']==''">
<dtml-var "searchallcust">
* call the sql method which select all
records.
</dtml-if>
</dtml-with>
so far it can return the correct result for me, but
i'm not sure whether is this function affect my Previous record
please let me know my problem as soon as
possible.