Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 4 of 4
  1. #1
    New to the CF scene
    Join Date
    Jan 2003
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Comboboxes populated from recoredsets

    hi

    How can I get a double combo box to have both its drop down lists populated by database query results, and the second box to be dependent on the contents of the first box?

    thanks

    Max

  • #2
    Senior Coder
    Join Date
    Jun 2002
    Location
    Nashua, NH
    Posts
    1,724
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Populate first combobox on the server.
    For the second combobox you can:
    1. Create a set of comboboxes each corresponding to a value in a first combobox. Do set display attribute depending on the selection in the first cb.
    2. Create array of values for each selection in the first cb; repopulate second when the first changes.
    3. Query server every time the first combobox changes and repopulate the second with returned values.

    The optimum solution would depend on how much data you plan to have and browsers you want to support....
    Vladdy | KL
    "Working web site is not the one that looks the same on common graphical browsers running on desktop computers, but the one that adequately delivers information regardless of device accessing it"

  • #3
    New to the CF scene
    Join Date
    Jan 2003
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    thank, but....

    I'm not very good at this, could you explain in more detail what it is I need to do, but also in simple terms as well???!!

    thanks

    Max

  • #4
    Senior Coder
    Join Date
    Jun 2002
    Location
    Nashua, NH
    Posts
    1,724
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: thank, but....

    Originally posted by mgoldsmith
    I'm not very good at this...
    You can hire me to write this code for you, 'cause short of doing this I explained it as simple as I could...
    Vladdy | KL
    "Working web site is not the one that looks the same on common graphical browsers running on desktop computers, but the one that adequately delivers information regardless of device accessing it"


  •  

    Posting Permissions

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