[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
===============================================================