[ic] query tag question

Ed LaFrance interchange-users@icdevgroup.org
Wed Mar 5 12:23:00 2003


At 10:10 AM 03/05/2003 -0500, you wrote:
>I was wondering if there is a way to pre-fetch (for lack of a better word)
>the page results from a query tag.
>
>For example:
>
>[query list=1 prefix=sql more=1 ml=10 sql="select * from products"]
>    [on-match]
>         Collect the sku's here
>    [/on-match]
>    [list]
>       [sql-param sku]<BR>
>    [/list]
>    [more-list]
>    <P>[more]
>    [/more-list]
>[/query]
>
>
>Returns me ~20 pages of items, for each page I want to collect
>the sku's for the 10 items displayed, but I do NOT want to do it
>in the [list] tag, I want to catch them before hand.
>
>Thanks.
>
>Tim

I'd suggest doing the query in Perl, then putting the results in an array 
ref. You can then manipulate that in any number of ways:

http://www.icdevgroup.org/cgi-bin/ic/docfly.html?mv_arg=ictags04.55

- Ed L.


===============================================================
New Media E.M.S.              Technology Solutions for Business
463 Main St., Suite D         eCommerce | Consulting | Hosting
Placerville, CA  95667        edl@newmediaems.com
(530) 622-9421                http://www.newmediaems.com
(866) 519-4680 Toll-Free      (530) 622-9426 Fax
===============================================================