Forums

This topic is locked

Multiple Searches

Posted 17 May 2002 11:12:02
1
has voted
17 May 2002 11:12:02 Matt Beadle posted:
Hi all

I have a problem: I have an access 2000 database with lots of dates in it. They are all start dates of weeks where a house is available to rent. I have a search page where the user can type in upto 6 different dates and see if they are available. Easy! Have a results page which shows them this using 6 recordsets searching WHERE tbleBookedWeeks = 'varWhatever'. (A request variable pointing to a search field on the previous page.) The problem is that I can't send this information to the next page when I want them to have a sort of shopping cart -"this is what you have booked". Ultradev Shopping cart cannot search using multiple recordsets so I cannot pass the info to the next page and then subsequent pages for the user to register, pay etc.

Any ideas out there in clever people land?

One little final thing: If I set up a shopping cart for just one item i.e (week) it shows the default value in the cart not the requested value from the search field??? Any ideas

Many thanks

Reply to this topic