<div id="RTEContent">Hv u try using the ZSearchInterface calling your ZSQL method (below). Try it. It will solve your problem except the layout is not good looking. Hiowever, you may to modify it to pass arguments to your ZSQL method. <br><br>Look for:<br> <dtml-if previous-sequence><br> <a href="<dtml-var URL><dtml-var sequence-query<br> >query_start=<dtml-var<br> previous-sequence-start-number>"><br> (Previous <dtml-var previous-sequence-size> results)<br>
</a><br> </dtml-if previous-sequence><br>and<br> <dtml-if next-sequence><br> <a href="<dtml-var URL><dtml-var sequence-query<br> >query_start=<dtml-var<br> next-sequence-start-number>"><br> (Next <dtml-var next-sequence-size> results)<br> </a><br> </dtml-if next-sequence><br><br>
Chan YH<br><br><b><i>Wolfgang.Schrecker@atosorigin.com</i></b> wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> Yes, you are right. Any other solution is welcome.<br><br>My ZSQLMethos is:<br><br>select<br>date_format(CONCAT(datej,'-',datem,'-00'),'%m.%Y') as "Abr._Monat"<br>, cardno as Kartennummer<br>,concat(pid_org,"-",bst) as ORG<br>,CONV(customer,10,10) as ID<br>,IFNULL(date_format(birthday,'%d.%m.%Y'), '&nsbp;') as Geburtstag<br>,plz<br>,date_format(CONCAT(LEFT(euro_start,4),'-',RIGHT(euro_start,2),'-00'),'%m.%Y')<br> as EURO_Start<br>,status<br>from AlterOrtEuro<br><br><dtml-sqlgroup where=""><br><br> <dtml-sqltest von_monat="" column="datem" op="ge" type="int" optional=""><br> <dtml-and><br> <dtml-sqltest von_jahr="" column="datej" op="ge" type="int" optional=""><br><br> <dtml-and><br> <dtml-sqltest bis_monat="" column="datem" op="le" type="int" optional=""><br> <dtml-and><br> <dtml-sqltest
bis_jahr="" column="datej" op="le" type="int" optional=""><br><br> <dtml-and><br> <dtml-if kartennummer=""><br> cardno like <dtml-sqlvar kartennummer="" type="string"><br> </dtml-sqlvar><br><br>and need the arguments above.<br><br>works well for the first page. But, at the bottom we have the (Next 20<br>results) and there in the link,<br>is no refenence to<br>"...... manage_test?<br>Kartennummer=50%25&von_Monat=&von_Jahr=&bis_Monat=&bis_Jahr=<br>&SUBMIT=Submit+Query"<br>as there is in the current page.<br><br>Naturally, when the next page is displayed, ( ...<br>manage_test?query_start=26&query='' )<br><br>the (bold) parameters from the first page are ignored and a new page is<br>displayed as if no arguments were relevant.<br><br>Why is 'query=''' empty ?<br>How would you do it ?<br><br><br>mit freundlichen Gr��en/best regards<br><br>Wolfgang Schrecker<br><br>"Partiality to the subjective view leads to an emphasis on the spritual,<br>while partiality
to the objective leads to an emphasis on the material"<br>aus: Daisaku Ikeda: Wisdom of the Lotos-Sutra Vol. V p. 7<br><br><br>* * * * * * * * L E G A L D I S C L A I M E R * * * * * * * *<br>This e-mail is destined for the above mentioned recipient. In case you<br>received this e-mail by accident, we would appreciate it if you could<br>contact the sender and delete all copies stored on your computer.<br>Please be aware that the security and confidentiality of electronic data<br>transmitted by e-mail is not completely guaranteed and that data may be<br>seen,<br>copied, downloaded or changed by third persons during transmission.<br>Atos Origin accepts no liability for the security and confidentiality of<br>data and documents sent by e-mail. Please make sure that all important<br>messages will be confirmed in writing by means of a telefax or a letter.<br>* * * * * * * * L E G A L D I S C L A I M E R * * * * * * *
*<br><br></dtml-if></dtml-and></dtml-sqltest></dtml-and></dtml-sqltest></dtml-and></dtml-sqltest></dtml-and></dtml-sqltest></dtml-sqlgroup></blockquote><br></div><p>
<hr size=1>Yahoo! Photos – Showcase holiday pictures in hardcover<br>
<a href="http://us.rd.yahoo.com/mail_us/taglines/photobooks/*http://pa.yahoo.com/*http://us.rd.yahoo.com/mail_us/taglines/photos/evt=38088/*http://pg.photos.yahoo.com/ph//page?.file=photobook_splash.html">Photo Books</a>. You design it and we’ll bind it!