[ic] sql and multipage

[New Media E.M.S.]

At 03:00 AM 6/3/2004, you wrote:

>I match a big problem using versions 5.x.x:
>If I use new sql form as:
>
>     [query
>      ml=30
>      more=1
>      type=list
>      sql=|
>           SELECT *
>           FROM products
>           WHERE CAT1='[scratch c1]'
>           ORDER by cat4, num_int, numero
>          |]
>      [list]
>.
>.
>query works but pages separations is not possible

You need your more_list, just like with Interchange searches:

     [more_list 0 0 0 ]
      [first-anchor]Prima[/first-anchor]
      [last-anchor]Ultima[/last-anchor]
      [next-anchor] <span class="titolo"> <br> Vai alla pagina successiva
</span>[/next-anchor]
      [prev-anchor] <span class="titolo"> Vai alla pagina precedente
<br></span>[/prev-anchor]
      [page-anchor]|$PAGE$[/page-anchor]
      [decade-next]<b>( 10 Successive )</b> [/decade-next]
      [decade-prev]<b>( 10 Precedenti )</b> [/decade-prev]
      [more]
[/more_list]

- Ed


>Using old style as:
>
>     [search-region more=1 search="
>       st=db
>       ml=30
>       fi=products
>       tf=CAT4
>       to=f
>       tf=num_int
>       to=n
>       tf=NUMERO
>       to=f
>       sf=CAT1
>       se=[scratch c1]
>       op=rm
>       sf=CAT2
>       se=[scratch c2]
>       op=rm
>       sf=CAT3
>       se=[scratch c3]
>       op=rm
>       rf=*
>     "]
>      [search-list]
>      [seti c4][item-field CAT4][/seti]
>.
>.
>.
>      [/search-list]
>      [more-list 0 0 0 ]
>      [first-anchor]Prima[/first-anchor]
>      [last-anchor]Ultima[/last-anchor]
>      [next-anchor] <span class="titolo"> <br> Vai alla pagina successiva
></span>[/next-anchor]
>      [prev-anchor] <span class="titolo"> Vai alla pagina precedente
><br></span>[/prev-anchor]
>      [page-anchor]|$PAGE$[/page-anchor]
>      [decade-next]<b>( 10 Successive )</b> [/decade-next]
>      [decade-prev]<b>( 10 Precedenti )</b> [/decade-prev]
>      [more]
>[/more-list]
>     [/search-region]
>
>Pages separations works but only one level sorting results possible (CAT4)
>That form works perfectly in version 4.x.x
>I need to present results on different pages sorting on 3 different level
>(as above) so, what could I do?
>Thanks
>Claudio Berselli
>
>
>_______________________________________________
>interchange-users mailing list
>interchange-users at icdevgroup.org
>http://www.icdevgroup.org/mailman/listinfo/interchange-users

===============================================================
New Media E.M.S.              Technology Solutions for Business
11630 Fair Oaks Blvd., #250   eCommerce | Consulting | Hosting
Fair Oaks, CA  95628          edl at newmediaems.com
(916) 961-0446                http://www.newmediaems.com
(866) 519-4680 Toll-Free      (916) 961-0447 Fax
===============================================================