Is there a way that I can, after going to the results page, click on another link to filter the information displayed even further? For instance, I'm looking at every entry containing this serial number, then I want to click on whatever category I desire.
I am using this same code for another website when we list all of our assets. On the main page I have a menu where the user can select which site to view. If they click "Ontario",
<a href="location.asp?LocDisplay=Ontario">Ontario</a> |
They are then taken to a page that displays only the assets located in Ontario.
SELECT * FROM assets WHERE Location LIKE '"&request.querystring("LocDisplay")&"' |
On this page, there is another menu where they can filter the results further by selecting a specific type of device, such as Desktop, Laptop, Server, Monitor, etc.
I would like to make the links on this menu take the user to another page (or stay on this one if possible) where they will view just the Desktops (or whatever they click) from that specific location.
I want to pull the LocDisplay variable and insert it into the link, followed by a variable for the type of device clicked.
Right now, I am testing this out by entering the link as follows:
<a href="location_device.asp?LocDisplay=Ontario?DeviceDisplay=Desktop">Desktops</a> |
This will open the location_device.asp page, but no data is displayed.
The SQL statement is like so:
SELECT * FROM assets WHERE Location LIKE '"&request.querystring("LocDisplay")&"' AND DeviceType LIKE
'"&request.querystring("DeviceDisplay")&"' |
What am I doing wrong? I'm sure it has to be something I did in the link.
Thanks!
Topic Options
Post Options
Thanks(0)
