XML based dynamic dropdown menus in ASP

[beeee]

I am trying to create an XML based set of nested drop down menus. Essentially you would have three (or n) menus (i.e. Make, model, year). Each menu is dependent on the value of the previous box to populate itself and is dynamically updated via JavaScript when its parent box is changed.

I know how to do this with JavaScript arrays, but populating the arrays in ASP from an SQL server can take some time, and the data is static within a 24 hour period. My idea is to have a XML doc stored on the server that the client can reference in the JavaScript routine and build the arrays on the client side w/o slowing the bogging down the page rendering with a SQL process.

Any help would be appreciated.

here is how I am currently doing it with ASP rendering inside of JavaScript.

<% iIDC = 1 %>
<% Do While Not rsIDCGet.EOF %>

laIDC[<%=iIDC%>] = new IDC();
laIDC[<%=iIDC%>].myName = "< -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[seoexpert]

An ADO Recordset object has an open method that can take an XML file as a parameter and parse it into a recordset. So you could have a SQL Server job that saved the XML file to the server, and use ADO within your ASP to get the values from the file.

Hope that was of some help -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --