Apr 10, 2008 05:45 PM|lespaul00|LINK
I have a MS Access Database called "site.mdb". It has a Site_info table that lists a number of sites across the US, and has different fields containing information about each site. I would like to create a webpage that pulls all of the
information from the different fields for a specific site and displays them dynamically. Maybe an SQL statement like this:
WHERE Site_Name = ??????
Of course the ?????? means I do not know how to allow the user to select the site (an initial page with all site names would be great, and a hyperlink for each. I'm thinking the each hyperlink can attach it's SITE_ID to the link's URL with the "&" syntax.
Then, the SITE_ID can be used on the results page in this SQL statement?).
Any help is greatly appreciated!!! I got it to work perfectly with CFML, but i'm trying to do it with ASP.NET!!! Thanks!