Professional Web Applications Themes

Multiple Selections - ASP Components

I have a multiple dropdown which have multiple selection. If I select multiple value on my multiple dropdown list and submit it,how can i write it on the tblotherlang sample code <select size="10" name="ddmultiplelang" multiple> <% qryNCDesc = "SELECT MultiLanguageID, MultiLanguageDesc FROM tbllang" Set rstNCDesc = Server.CreateObject("ADODB.Recordset") rstNCDesc.open qryNCDesc, cndpr %> <% Do While NOT rstNCDesc.EOF %> <option value="<%=rstNCDesc.Fields("MultiLanguageID").Valu e%>"><%=rstNCDesc.Fields("MultiLanguageDesc").Valu e%></option> <% rstNCDesc.MoveNext Loop %> I have this three table: tbllang MultiLanguageID LanguageDesc 1 Filipino 2 English 3 Japanese tblmain NameID name language MultiLanguage 1 Joan Filipino a 2 Katrina English 3 Kristine Japanese a tblotherlang OtherLangID OthernameID othermultilaguange 1 ...

  1. #1

    Default Multiple Selections

    I have a multiple dropdown which have multiple selection.

    If I select multiple value on my multiple dropdown list and submit it,how
    can i write it on the tblotherlang

    sample code

    <select size="10" name="ddmultiplelang" multiple>
    <%

    qryNCDesc = "SELECT MultiLanguageID, MultiLanguageDesc FROM tbllang"

    Set rstNCDesc = Server.CreateObject("ADODB.Recordset")
    rstNCDesc.open qryNCDesc, cndpr
    %>
    <%
    Do While NOT rstNCDesc.EOF
    %>
    <option
    value="<%=rstNCDesc.Fields("MultiLanguageID").Valu e%>"><%=rstNCDesc.Fields("MultiLanguageDesc").Valu e%></option>
    <%
    rstNCDesc.MoveNext
    Loop
    %>




    I have this three table:

    tbllang

    MultiLanguageID LanguageDesc
    1 Filipino
    2 English
    3 Japanese


    tblmain

    NameID name language MultiLanguage
    1 Joan Filipino a
    2 Katrina English
    3 Kristine Japanese a


    tblotherlang

    OtherLangID OthernameID othermultilaguange
    1 1 2
    2 1 3
    3 3 1




    How can i insert the value on tblotherlang.othernameID and
    tblotherlang.othermultilanguage?

    Please help!

    THANKS


    jjuan Guest

  2. #2

    Default Re: Multiple Selections


    "jjuan" <jp4the_clan> wrote in message
    news:%23LxN0lySHHA.3980TK2MSFTNGP02.phx.gbl...
    >I have a multiple dropdown which have multiple selection.
    >
    > If I select multiple value on my multiple dropdown list and submit it,how
    > can i write it on the tblotherlang
    >
    > sample code
    >
    > <select size="10" name="ddmultiplelang" multiple>
    > <%
    >
    > qryNCDesc = "SELECT MultiLanguageID, MultiLanguageDesc FROM tbllang"
    >
    > Set rstNCDesc = Server.CreateObject("ADODB.Recordset")
    > rstNCDesc.open qryNCDesc, cndpr
    > %>
    > <%
    > Do While NOT rstNCDesc.EOF
    > %>
    > <option
    > value="<%=rstNCDesc.Fields("MultiLanguageID").Valu e%>"><%=rstNCDesc.Fields("MultiLanguageDesc").Valu e%></option>
    > <%
    > rstNCDesc.MoveNext
    > Loop
    > %>
    >
    >
    >
    >
    > I have this three table:
    >
    > tbllang
    >
    > MultiLanguageID LanguageDesc
    > 1 Filipino
    > 2 English
    > 3 Japanese
    >
    >
    > tblmain
    >
    > NameID name language MultiLanguage
    > 1 Joan Filipino a
    > 2 Katrina English
    > 3 Kristine Japanese a
    >
    >
    > tblotherlang
    >
    > OtherLangID OthernameID othermultilaguange
    > 1 1 2
    > 2 1 3
    > 3 3 1
    >
    >
    >
    >
    > How can i insert the value on tblotherlang.othernameID and
    > tblotherlang.othermultilanguage?
    Assuming that ddmultiplelang is contained in a form, the ASP script that
    form posts to will receive the user selection as an array:

    <html><body><form method=post action=#>
    <select name=ddmultiplelang size=10 multiple>
    <option value=1>English</option>
    <option value=2>Filipino</option>
    <option value=3>French</option>
    <option value=4>German</option>
    <option value=5>Japanese</option>
    <option value=6>Russian</option>
    <option value=7>Spanish</option>
    </select><input type=submit /></form>
    <%
    For i = 1 to Request.Form("ddmultiplelang").count
    Response.Write Request.Form("ddmultiplelang")(i) & "<br>"
    Next
    %>
    </body></html>



    So, assuming you also provide the posted-to ASP with the id of the current
    user, you'd need to insert a row for each element in the array.


    -Mark


    > Please help!
    >
    > THANKS
    >
    >

    Mark J. McGinty Guest

Similar Threads

  1. datagrid multiple selections
    By dave in forum Macromedia Flash Data Integration
    Replies: 0
    Last Post: May 2nd, 04:59 PM
  2. HTTPService with multiple selections?
    By dsl239 in forum Macromedia Flex General Discussion
    Replies: 11
    Last Post: June 5th, 08:55 PM
  3. Charting Multiple Selections in dataGrid
    By csgdemon in forum Macromedia Flex General Discussion
    Replies: 0
    Last Post: May 12th, 07:15 PM
  4. Pass Multiple Selections?
    By GPNET in forum Macromedia Dynamic HTML
    Replies: 1
    Last Post: April 14th, 08:40 PM
  5. Multiple Selections from combo box
    By Stefan in forum Microsoft Access
    Replies: 2
    Last Post: June 30th, 09:49 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not 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