Help! ASP: Filterin a list (query)

programming
1

Hi, I usually don’t have to deal with this, but I was asked to do a simple update and I think I screwed something up!:cantlook:

We have a list, drawn from an Access databasee and that list is organized by semester- I was asked if I can just change the semester- from 2007 to 2008. I figured that looked easy and just changed the following code.


select name="session"> <option value="Spring 2008"<%=((querySession == "Spring 2008")?"selected":"")%>>Spring 2008</option><option value="Summer 2008" <%=((querySession == "Summer 2008")?"selected":"")%>>Summer 2008</option> </select>
  1. user selects a sesssion (Spring/or Summer)
  2. User submits the form
  3. the list returns with only students registered for (spring/ summer)
  4. sip some coffee and enjoy!

So basically, once the user selects the session (let say ‘spring’ for example) then, it displays a list of students where in database session == spring.

But now the list dosent change at all! help!
Here is the complete file:

http://gearup.hawaii.edu/registrations/runningstart/reg_list.txt