Hi,

I have a set of three asp pages that work like this:
Page 1: User selects a parent category form a dropdown menu
Page 2: The info is passed to page two and the subcategories associated with the selected parent category are displayed as hyperlinks.
Page 3: Selecting a Subcategory from page 2 takes the user to page three where the user is required to enter a zipcode to search for contractors associated with the chosen subcategory. The results of the search are then displayed on the same page.

See this in action at: www.your-personalassistant.com/prototalk/index.asp

Download the zipped app at:
www.your-personalassistant.com/prototalk/prototalk.zip

<b>This is what I need help with:</b>

I need to modify page three to display its results based on a condition as described below.

The database table for the subcategories (ServicesChild) has a column called "DisplayOptions" in Text Format.

I want page three to display the details of the Contractors only if that subcategory's "DisplayOptions" field is set to "Yes"

I am open to any alternative options if mine doesnt make sense.

You help is appreciated.

Best regards,

Zain

Zain Magsi

I'm used to using PHP in Dreamweaver (and I'm not really a coder either) so I don't know if ASP works in the same way, but when I bind a RecordSet to a page I get the option to Filter and/or Sort my recordset.

In your case you would want to Filter the column 'Display Options' so that the 'Entered Value' = 'Yes'.

Apologies if I've misunderstood what you're asking for. I also found an extension that works using PHP called Conditional Region which does a similar thing to the above but at the page level rather than database level. You may be able to find a similar extension for ASP.