Re: [ic] query tag question

[Ed LaFrance <suppressed>]

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        suppressed
(530) 622-9421                http://www.newmediaems.com
(866) 519-4680 Toll-Free      (530) 622-9426 Fax
=============================================================== 

_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users