Ask a Question related to ASP Components, Design and Development.
-
jjuan #1
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
-
datagrid multiple selections
How do i go about dealing with multiple selections within a datagrid? Any tutorials or examples. Thanks Dave -
HTTPService with multiple selections?
I have a form with a list of criteria that I need to send to the server for processing. Does anyone know how to send it with an HTTPService ? I have... -
Charting Multiple Selections in dataGrid
I'm stumped. I want my chart to add a series for each row selected from a corresponding dataGrid. I've used the Series Selection example (under... -
Pass Multiple Selections?
We have a form ( http://www.gpnet.biz/quote/quote.htm ) that has several multi selection lists. We're also using formmail.php to process the form... -
Multiple Selections from combo box
I have a memo field I would like to populate like a combo box. However I would like to be able to make several choices from the list to populate... -
Mark J. McGinty #2 Re: Multiple Selections
"jjuan" <jp4the_clan@yahoo.com> wrote in message
news:%23LxN0lySHHA.3980@TK2MSFTNGP02.phx.gbl...Assuming that ddmultiplelang is contained in a form, the ASP script that>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?
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
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
