I am working on an advanced search using FrontPage, dropdown boxes, and the Database Results Wizard.
If you go to http://www.resortequitymarketing.com/Listings/ResortSearch.asp
you can see exactly what I"m dealing with.
On the first page (called ResortSearch.asp) I have a dropdown box from which the user selects a 'ResortName'. They are then taken to a page (called ResortResults.asp) displaying the database results region that contains all the matching results.
If the user clicks an "advanced search" hyperlink they are then taken to a page (called ResortAdvancedSearch.asp) where they (hypothetically) narrow their search down by selecting from dropdown boxes for 3 fields: Bedrooms, Bathrooms, and PriceRange. I want the resort name to be 'remembered' from the previous page. After clicking 'submit' they will then taken to a page (called AdvancedResortResults.asp)
that shows the records that match all 4 fields (ResortName, Bedrooms, Bathrooms, and PriceRange).
The "advanced search" link appears below the table with each result. (I don't know how to do a link with parameters if it is NOT in the database results region.) To 'remember' the ResortName I currently have the "Advanced Search" hyperlink parameters set to this:
ResortAdvancedSearch.asp currently has its Advanced Form Properties set equal to the same thing (making ResortName a hidden field, I believe. It doesn't necessarily need to be hidden though.)
Right now it's not working. What do I need to do to fix it?
In summary, I want the ResortName to be passed to the ResortAdvancedSearch.asp and then to AdvancedResortResults.asp along with Bathrooms, Bedrooms, and PriceRange.
Thank you very much for any assistance.