Posted on 2005-05-06
I created a site where the user can see all the info concerning extreme sports in air, water and mountain. I have 2 pages, air.asp (where all the info of the sports in air are retrieved and displayed from the database.) and locations.asp (this page displays each sport and its locations where it is available). So, the problem is the following. In the first page i have a list/menu where all the locations of bunjee jumbing for example are displayed. )Ofcourse i have buttons so as to go to the next or previous air sport. Once the user selects from the list for example the location OLYMPUS i want him o be riderected to the locations.asp page but display the apropriate info, that is, Bunjee jumping in Olympus. I have written an SQL statement so as to select each time the apropriate sport from the recordset. The problem is that although the user is redirected to the next page it displays the sport name and locations of the first in the recordset and not the specific (bunjee in Olympus. it displays bunjee in KORINTHOS). The two fields the recordset uses are SportName and LocationName from 2 separated tables. I have managed to pass from the air.asp page the parameters (SportName and LocationName) as i can see from the address bar BUT yet i dont know how to take from the address bar and use them in my code. I give you the code of the list/menu from air.asp page, because i think i have confused you. Thank you for your help. I so badly need it!!!
<form action="../../SPORTS_LOC/Location.asp?LocationName=<%=(Recordset2.Fields.Item("LocationName").Value)%>" name="form1" method="post" >
<select name="select" id="select" onChange="location=document.form1.select.options[document.form1.select.selectedIndex].value;" value="GO">
<option selected value="null">
<--Please Select a Location-->
<% While NOT Recordset2.EOF %>
If (Recordset2.CursorType > 0) Then