[ic] Opening multiple browsers, more paging does not function correctly inside query

Ron Phipps interchange-users@interchange.redhat.com
Sun Jun 2 02:02:01 2002


Hello,

I'm working on a results page which contains a [query] section with
match limit set to 10.  If I open one browser and visit this page the
paging works correctly and I can switch from page to page.  However in
this scenario the paging breaks and the results are incorrect:

1. Open one browser (browser A) to the results page with one parameter
and return more then 10 results. (Let's use Cat Food for an example).

Url:
product_group_results?mv_session_id=ahFpKGUu&mv_pc=341&pg_id=267&sort=sk
u

Page 1 more link:
scan/MM=52ab747d473e15346aa9856ccad315dc:0:9:10?mv_session_id=ahFpKGUu&m
v_pc=1056&mv_more_ip=1&mv_nextpage=product_group_results&pf=sql&pg_id=26
7&sort=sku

Page 2 more link:
scan/MM=52ab747d473e15346aa9856ccad315dc:10:17:10?mv_session_id=ahFpKGUu
&mv_pc=1036&mv_more_ip=1&mv_nextpage=product_group_results&pf=sql&pg_id=
267&sort=sku

2. Open another browser (browser B) to the results page with a different
parameter and return more then 10 results. (Let's use Dog Food for an
example).

Url:
product_group_results?mv_session_id=ahFpKGUu&mv_pc=775&pg_id=89&sort=sku

Page 1 more link:
scan/MM=52ab747d473e15346aa9856ccad315dc:0:9:10?mv_session_id=ahFpKGUu&m
v_pc=1163&mv_more_ip=1&mv_nextpage=product_group_results&pf=sql&pg_id=89
&sort=sku

Page 2 more link:
scan/MM=52ab747d473e15346aa9856ccad315dc:10:19:10?mv_session_id=ahFpKGUu
&mv_pc=1138&mv_more_ip=1&mv_nextpage=product_group_results&pf=sql&pg_id=
89&sort=sku

3. Go to browser A and click on the next page and the results for
browser B's second page will be shown.

It's as though the more links point to the resultset for the last search
made instead of the search being viewed even though the url's are
different.  Any ideas of what can cause this scenario?  Is there any
debugging tips for a situation like this?

Below is the relevant part of my code (with html snipped):

[query sql="SELECT sku, title, list_description, products.image,
brand.name AS brand_name, price, sale_price, review_average_rank FROM
products LEFT JOIN brand ON products.brand_id = brand.brand_id LEFT JOIN
review_summary ON products.sku = review_summary.link_id WHERE
prod_group_id = [cgi pg_id] ORDER BY [scratch sort_order]" form=|
							pg_id=[cgi
pg_id]
sort=[scratch sort_order]
						| type=list ml=10
more=1]

[on-match]

[more-list]
	[more]
[/more-list]

[/on-match]

[list]
	Sku: [sql-code]
	Title: [sql-param title]
	Average Rank: [sql-param review_average_rank]
[/list]

[/query]

I'd like to be able to allow our users to run multiple searches at the
same time if possible.

Thanks!
-Ron