Dynamic drop down and page refresh

Results 1 to 2 of 2

Thread: Dynamic drop down and page refresh

  1. #1
    Join Date
    Dec 1969

    Default Dynamic drop down and page refresh

    I am new to ASP and want to create a page where there are multiple drop down boxes where each subsequent drop down is filtered by the previous drop down. The data that I want to populate the drop downs is to be returned from SQL server. I have managed to create a page where I can do this but it queries the database when the page loads and inserts the values into javascript arrays which are then used for the drop downs. The problem is that 500,000 + records are being returned which makes the page unusably slow. Therefore what I need is guiadnce on how to allow the user to make a selection from a drop down and then the page refreshes (executes a query for the next drop down) and then displays the next drop down on the page. The following article http://www.4guysfromrolla.com/webtech/061399-1.shtml suggests this as option 2 a and states that it is truly trivial code. I am so new to ASP that this is even over my head! Does anyone know of a "how to" guide for this or any sample code to do this? I am using Dreamweaver MX.<BR><BR>Thanks in advance, Dan

  2. #2
    Join Date
    Dec 1969

    Default http://www.ClearviewDesign.com/Newbie

    Look at my demo there that shows category/subcategory &#060;SELECT&#062;s.<BR><BR>It only shows two &#060;SELECT&#062;s, but hopefully you can see how to extend the logic to more levels.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts