Cascading Dropdownlist populated from previous with mssql

This is entirely in classic asp. So we need 3 dropdownlists which are populated from mssql. The second dropdown is dependant on the first selction and the 3rd on the 2nd. However there may not be 3 levels so when there are no more selections that category is used. Now I do have the starts of all of this using javascript asp and a bit of xml. I am struggling to get it to work though so need a fresh pair of eyes. I am pretty sure this is no longer than 30 minute for someone who knows.