How can I use combo box to control data in table

Ask a Question related to Dreamweaver AppDev, Design and Development.

  1. #1

    Default How can I use combo box to control data in table

    Does anyone know if this scenario is possible and if so, what steps I could
    take in DreamWeaver to make it happen (I am using generic tables here for my
    example):

    Suppose we have an Authors table and a Books table. I want to create a web
    page in DreamWeaver MX 2004 whereby I have a combo box at the top containing
    Authors and a table underneath showing Books written by the given author. When
    the user changes the Author in the combo box, the table automatically
    repopulates with the books by the given author. I am using JSP as my
    application model.

    Does anyone know of an example that might suit this purpose or could someone
    generically walk me through? I am not sure how to map the Author combo box to
    the Recordset of the Books nor do I know how to refresh the screen whenever the
    Author combo box is changed.

    Thanks for any help.

    Todd

    rtmarkley Guest

  2. Similar Questions and Discussions

    1. Combine table 3 columns in a combo box?
      I need a combo box to display "lastName, firstName - phone". I have these 3 columns in my database. Can anyone provide a short cfc to xml script I...
    2. How to take data out of table, restructure the table and then put the data back in
      Hi All Wonder if you could help, I have a bog standard table called STOCKPRICES that has served me well for a while, but now I need to change the...
    3. How to display a set of data in a data grid when drivenby a combo box?
      I am trying to build a page where the user can select a syle of food (i.e. chinese, italian etc) from a combo. I would then want the relevent...
    4. Combo box writes wrong column to table
      I used the combo box wizard to make a combo box which draws its list from a table called Location. The table consists of only two fields, LocID and...
    5. Using Table control in a custom composite control. Control does not render properly in design time.
      All, I have written a very simple custom composite control that includes a control of type System.Web.UI.WebControls.Table. The control...
  3. #2

    Default Re: How can I use combo box to control data in table

    hi yea,
    [url]http://www.kermy.com/extensions/DynamicDDL.asp[/url]

    this is a free extension to do what you want in jsp, he has got a commercial
    one too but that is for the 3 dynamic dropdown.


    give the free one a go.

    twocan's






    "rtmarkley" <webforumsuser@macromedia.com> wrote in message
    news:d02omn$mke$1@forums.macromedia.com...
    > Does anyone know if this scenario is possible and if so, what steps I
    > could
    > take in DreamWeaver to make it happen (I am using generic tables here for
    > my
    > example):
    >
    > Suppose we have an Authors table and a Books table. I want to create a
    > web
    > page in DreamWeaver MX 2004 whereby I have a combo box at the top
    > containing
    > Authors and a table underneath showing Books written by the given author.
    > When
    > the user changes the Author in the combo box, the table automatically
    > repopulates with the books by the given author. I am using JSP as my
    > application model.
    >
    > Does anyone know of an example that might suit this purpose or could
    > someone
    > generically walk me through? I am not sure how to map the Author combo
    > box to
    > the Recordset of the Books nor do I know how to refresh the screen
    > whenever the
    > Author combo box is changed.
    >
    > Thanks for any help.
    >
    > Todd
    >

    twocan's Guest

  4. #3

    Default Re: How can I use combo box to control data in table

    Does this work for JSP's?
    rtmarkley Guest

  5. #4

    Default Re: How can I use combo box to control data in table

    [url]http://www.kermy.com/extensions/index.asp[/url]

    it says so here




    "rtmarkley" <webforumsuser@macromedia.com> wrote in message
    news:d02tk2$t7m$1@forums.macromedia.com...
    > Does this work for JSP's?

    twocan's Guest

  6. #5

    Default Re: How can I use combo box to control data in table

    rtmarkley

    Make the combo box a jump menu. Then use this to pass the authors id value
    to the page. Modify your recordset to filter by the author id passed.

    Brendan

    "rtmarkley" <webforumsuser@macromedia.com> wrote in message
    news:d02omn$mke$1@forums.macromedia.com...
    > Does anyone know if this scenario is possible and if so, what steps I
    could
    > take in DreamWeaver to make it happen (I am using generic tables here for
    my
    > example):
    >
    > Suppose we have an Authors table and a Books table. I want to create a
    web
    > page in DreamWeaver MX 2004 whereby I have a combo box at the top
    containing
    > Authors and a table underneath showing Books written by the given author.
    When
    > the user changes the Author in the combo box, the table automatically
    > repopulates with the books by the given author. I am using JSP as my
    > application model.
    >
    > Does anyone know of an example that might suit this purpose or could
    someone
    > generically walk me through? I am not sure how to map the Author combo
    box to
    > the Recordset of the Books nor do I know how to refresh the screen
    whenever the
    > Author combo box is changed.
    >
    > Thanks for any help.
    >
    > Todd
    >

    Singularity.co.uk Guest

  7. #6

    Default Re: How can I use combo box to control data in table

    good thinkin.




    "Singularity.co.uk" <Brendan.Collins@RemoveThisSingularity.co.uk> wrote in
    message news:d044d0$pj9$1@forums.macromedia.com...
    > rtmarkley
    >
    > Make the combo box a jump menu. Then use this to pass the authors id
    > value
    > to the page. Modify your recordset to filter by the author id passed.
    >
    > Brendan
    >
    > "rtmarkley" <webforumsuser@macromedia.com> wrote in message
    > news:d02omn$mke$1@forums.macromedia.com...
    >> Does anyone know if this scenario is possible and if so, what steps I
    > could
    >> take in DreamWeaver to make it happen (I am using generic tables here for
    > my
    >> example):
    >>
    >> Suppose we have an Authors table and a Books table. I want to create a
    > web
    >> page in DreamWeaver MX 2004 whereby I have a combo box at the top
    > containing
    >> Authors and a table underneath showing Books written by the given author.
    > When
    >> the user changes the Author in the combo box, the table automatically
    >> repopulates with the books by the given author. I am using JSP as my
    >> application model.
    >>
    >> Does anyone know of an example that might suit this purpose or could
    > someone
    >> generically walk me through? I am not sure how to map the Author combo
    > box to
    >> the Recordset of the Books nor do I know how to refresh the screen
    > whenever the
    >> Author combo box is changed.
    >>
    >> Thanks for any help.
    >>
    >> Todd
    >>
    >
    >

    twocan's Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139