Hi again. I'm trying to make an applicaiton which involves searching for a particular case, allowing the user to pick a particular case, and then viewing the details about that particular case. Here is what I want to do. I have a page where a user types in a case number, phone number, etc. to search for. The search returns a list of results matching this criteria and makes the results hyperlinked. The user then clicks on one of the hyperlinked results to view the details of that particular case. I have some ASP knowledge...how easy would something like this be to create? Does anybody know of any tutorials available to do something like this? Thanks for any help.
Well that depends on where you want me to start,.... the search part? the creating the link part, the doing the individual look up. What do you current know about asp and databases? What tools are you using?
Generally I'll use a Visual Studio product of some description. But like I said, do you have a working search page at the moment that displays results? if so, post that and I'll add a section in that creates the links.
I have two pages right now. I have a search.htm which contains a LastName and FirstName input boxes and a search button. The search.htm passes this information to search.asp, which is in the code below.
I would like the results hyperlinked so a user can click on a link, then show the details about a particular case. I'm sorry to have taken so long but things happen around the office. Thanks again for you help.
I have attached a new version of that code for you. Basically I have added an extra column to the end of you table with the link. There is a variable set up to hold the page you want to got to and the querystring variable which you will need to change to point to whatever you want to call your page to display the full details.
thank you for the page. it was very generous of you. i had no idea it was actually that simple. now i have a new question for you. how do i go about making the displayCase.asp page? i know the sql statement i want to use, but exactly how would i begin the page so it would display those results? thanks again for your help!!!!
When I say how would i begin the page, i mean, how do i carry over that inforamtion from the previous page? Do I put a statement in my sql string? I'm thinking it will go in the WHERE clausse but i'm still unsure. Thanks for your help!