Link to home
Start Free TrialLog in
Avatar of shah2k
shah2k

asked on

paging-site server

Hi,
In the site server, in the dept.asp file i have listed all the products along with check boxes (to enable multiple selection of products )and on clicking a button at the end of the page all the selected items gets added to the basket at one go.

Now i want to use paging for that to limit the no. of products in one page.if i use the std. paging with previous and next links,only the products selected in the last page is getting added.

for eg.if i select one item from the first page and one from the second page ,the item selected in the second page is only added ( i think,b'cos the loop starts again when calling  the next page as the current page) and previous checked values i am not able to pass across pages.

How to get all the checked values across the pages and finally add everything to the basket page?

Help to solve my problem.
thanks
Avatar of hobster
hobster

There are several solutions to this.

1. Everytime you click Next and Previous, you need to pass the selected products' ids to the page you're going to.

2. Use a temporary table to store the selected products. For example, you're on page 1 and you select 2 products and then you click Next. Before going to the next page, add these two product IDs to a table and then go to the next page. When you click Add to Basket, go to this table, pull up all the IDs and add them to the basket.
Avatar of shah2k

ASKER

ok, fine. if i have more than one customer shopping simultaneously how can i use a temporary database concept
where i can add the items for only one customer?
is there any possibility to have more than one customer can store there items in the temporary database simultaneously?
Sure, in Site server, everytime a customer comes to your store, Site Server gives them a customer id. You can store that id in the database also so you can differentiate which products were added by which customers.
Avatar of shah2k

ASKER

I am a beginner so i find difficult to understand the concept so please explain in detail.
usually we will have one column so that we can insert new rows as they go on adding the product .if i have two customers how will i store the values eventhough they have got different shopper ids.i am not thorough with the temporary database concept can u please brief me about that. is it like this a temporary database will be created for each customer
ASKER CERTIFIED SOLUTION
Avatar of jpraveen
jpraveen

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial