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.