# Help! ASP: Filterin a list (query)

**URL:** <https://forum.kirupa.com/t/help-asp-filterin-a-list-query/254972>\
**Category:** programming\
**Created:** [March 17, 2008, 8:30pm UTC](https://forum.kirupa.com/t/help-asp-filterin-a-list-query/254972 "2008-03-17T20:30:15Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![RussianBeer](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/russianbeer/32/152_2.png) [@RussianBeer](https://forum.kirupa.com/u/RussianBeer)\
**Post date:** [March 17, 2008, 8:30pm UTC](https://forum.kirupa.com/t/help-asp-filterin-a-list-query/254972/1 "2008-03-17T20:30:15Z")

</div>

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.

```auto

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](http://gearup.hawaii.edu/registrations/runningstart/reg_list.txt)