Hi there,

I am working with Dreamweaver and have some understanding, though limited of basic ASP for recordsets, variables etc.

I have a news page, where the news is organised into categories and sub-categories. For example:

Sports
Football
Rugby
Athletics
Entertainment
Film
Music
Theatre

The categories and sub categories are stored in the same table, and have a unique ID assigned to them. There is a column which identifies the parent category for the sub-categories. The news pieces themselves have the ID of the sub category or category stored in a column of their record.

What I want to be able to do is if someone does a search say in Entertainment, the results from all of the entertainment sub categories come up.

I assume I'm basically going to need one recordset which looks up the ID for each of the sub-categories of the selected category, and then another which uses this list to select the news articles. What I don't know how to do is load the list of IDs into a variable to be used in the recordset!

Can anybody help?

Many thanks in advance!

Dan