Multiple drop-down boxes

Results 1 to 4 of 4

Thread: Multiple drop-down boxes

  1. #1

    Default Multiple drop-down boxes

    I want to create an application with multiple drop-down boxes that receive data from an Oracle database. <BR><BR>For example, I have a drop-down box1 that would display all the orderID from an Orders table and when the user selects an Order, it would then retrieve all the Items associated to that order and display them in the second drop-down box. <BR><BR>I use a COM object to retrieve the data from my Oracle database to write out the OPTION VALUE part of the SELECT tag for the first drop-down box. However, I&#039m not sure how to write the data for the second drop-down box when the user selects an order. If I have to rewrite the page, how does that affect the first drop-down box without having to hit the database again for the same data?<BR><BR>Thank you very much for your help!!!!!<BR><BR>Michael

  2. #2
    Franco Guest

    Default RE: Multiple drop-down boxes

    Michael<BR><BR>Have you looked at using frames or page objects/remote cripting? Both mean a less hits to the database but are a bit less straightforward.<BR><BR>Good luck!<BR><BR>Franco

  3. #3
    KUMAR S Guest

    Default RE: Multiple drop-down boxes

    If u use Frames concept you can easily do that. You need not call the same asp page and it won&#039t hit the database again. With that Frameset tag concept you can call asp page which will display other drop-down box.<BR><BR>kumar

  4. #4
    Join Date
    Dec 1969

    Default RE: Multiple drop-down boxes

    Thank you Kumar. I did think about that, but what if there are more than two, would you then use #frames per #frames? How efficient and what are performances issues with multiple frames?<BR><BR>Thank you again, <BR>Michael

Posting Permissions

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