Multiple Selections

jjuan · Feb 8, 2007

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").Value%>"><%=rstNCDesc.Fields("MultiLanguageDesc").Value%></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

Mark J. McGinty · Feb 8, 2007

jjuan said:
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").Value%>"><%=rstNCDesc.Fields("MultiLanguageDesc").Value%></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

Multi select options in a menu	1	Oct 30, 2022
I dont get this. Please help me!!	2	Jan 24, 2023
Filter table rows based on multiple checkboxes value	2	Jan 13, 2023
HCaptcha - How to stop page from refreshing on submit if captcha is not checked/validated	1	Aug 29, 2023
How do I get the if statement correct in the lines that has it in the program?	2	Mar 16, 2023
processing mutiple checkbox selections in vbscript	4	Sep 24, 2009
Add Image and label dynamically inside the dropdown	2	Mar 11, 2022
Survey details won't go through using php, ajax, Mysql	0	Oct 26, 2023

Multiple Selections

jjuan

Mark J. McGinty

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads