Array subsets using ASP VBSript

[JamieHowarth0]

Hi there,

I'm new to the website - am a fairly seasoned ASP programmer and am working on a commercial application for my newly-founded business regarding e-commerce applications.

I have an array of items that I loop through to produce a category "tree" as such.
It's a base-10 array (0 to 9, then using digit index to work out parent categories and so on), so:
Top category = 0
First sub-category = 00
Second sub-category = 01
Second top category = 1

I'm using a Server Recordset object and MS Access (to be migrated to SQL Server at later date) connection to retrieve category information from a database and then manipulate it by converting it to an array.
Using the example above, how do I remove the first and second sub-categories from the array? Do I have to do a loop through the whole array and redefine it without the information I want to exclude (will take a performance hit as the removal will be performed on user input) or is there a quicker way?

Many thanks in advance,

medicineworker
P.S. If you want to see code samples to help answer the question please PM me & I will provide them.

[jhardman]

Welcom to the scripts DN. I hope we can be of service.
They absolutely need to be removed, or is it enough to set them to null?
Jared

[JamieHowarth0]

Hi jhardman,

Sorted it in the end - looped through array, discounting the "minimised" (unneeded) categories, then printed array.
Will prob end up switching to ASP.NET TreeView controls with XML-based sitemap.config files (sitemap to be retrieved from DB categories) as I need to upgrade all my portfolio sites to .NET at some stage for a big contract coming up.

Cheers!

medicineworker/MPDDK-mm4