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


<%

qryNCDesc = "SELECT MultiLanguageID, MultiLanguageDesc FROM tbllang"

Set rstNCDesc = Server.CreateObject("ADODB.Recordset")
rstNCDesc.open qryNCDesc, cndpr
%>
<%
Do While NOT rstNCDesc.EOF
%>
value="<%=rstNCDesc.Fields("MultiLanguageID").Value%>"><%=rstNCDesc.Fields("MultiLanguageDesc").Value%>
<%
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

Re: Multiple Selections

am 08.02.2007 09:44:39 von mmcginty

"jjuan" wrote in message
news:%23LxN0lySHHA.3980@TK2MSFTNGP02.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
>
>

> <%
>
> qryNCDesc = "SELECT MultiLanguageID, MultiLanguageDesc FROM tbllang"
>
> Set rstNCDesc = Server.CreateObject("ADODB.Recordset")
> rstNCDesc.open qryNCDesc, cndpr
> %>
> <%
> Do While NOT rstNCDesc.EOF
> %>
> > value="<%=rstNCDesc.Fields("MultiLanguageID").Value%>"><%=rstNCDesc.Fields("MultiLanguageDesc").Value%>
> <%
> 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:

Re: Multiple Selections

"jjuan" wrote in message
news:%23LxN0lySHHA.3980@TK2MSFTNGP02.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
>
>
> <%
>
> qryNCDesc = "SELECT MultiLanguageID, MultiLanguageDesc FROM tbllang"
>
> Set rstNCDesc = Server.CreateObject("ADODB.Recordset")
> rstNCDesc.open qryNCDesc, cndpr
> %>
> <%
> Do While NOT rstNCDesc.EOF
> %>
> > value="<%=rstNCDesc.Fields("MultiLanguageID").Value%>"><%=rstNCDesc.Fields("MultiLanguageDesc").Value%>
> <%
> 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:

English
Filipino
French
German
Japanese
Russian
Spanish

<%
For i = 1 to Request.Form("ddmultiplelang").count
Response.Write Request.Form("ddmultiplelang")(i) & "
"
Next
%>




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
>
>