PDA

View Full Version : Help! ASP: Filtering a list (query)


Deterius
03-20-2008, 01:41 AM
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!

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.
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>


Complete .asp file in txt format:
http://gearup.hawaii.edu/registrations/runningstart/reg_list.txt

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: