Forums
This topic is locked
Default option when filtering a recordset
Posted 24 Jul 2007 16:55:00
1
has voted
24 Jul 2007 16:55:00 Ryan Preece posted:
Call Me a Thicky here but I'm simply going blank!I want to filter and display a set of users via 2 list menus and a from.
I have a list of star signs in one list and male / female in the other.
Now - I can filter all starsigns easily enough and even do it so it shows all males or females of that star sign but I can seem to reset it to show all. I've added the all option in both list menus but can't remember for the life of me how to default it?
I.e. if I'm showing all scorpio males and want to show both male and females what do I use as the default value in the SQL or the list menu???
the code looks like this so far:
SELECT *
FROM browse
WHERE star_sign = MMColParam AND gender = MMColParam2
Both MMColparam variables are Request.queryStrings to obtain the users choice
Cheers everybody