By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,905 Members | 894 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,905 IT Pros & Developers. It's quick & easy.

Getting dropdown value

P: n/a
I know this is supposed to be easy but I can't get this to work. I
have a dropdown that pulls all the Projects (tp_title) available. All
I want to do is get the ID (tp_id) of that record so I can get the
developer assigned to that project (tp_assigned_to). Then, when I get
the developer, I need that to be redirected to a second page.

Example Code:
......
function getProject(){
//I know that this gets the selected value of the dropdown
var cdoProject = document.frmSoftware.cdoProject.options[cdoProject.selectedIndex].value

//but how do I get tp_id to get tp_assigned_to?????

}
function Submit(){
document.frmSoftware.action =
"Process.asp?Developer=<%=Request.Form("XXX")% >";
document.frmSoftware.submit();
}
....
<form name="frmSoftware" method="post">
.....

Set cmd.ActiveConnection = oConn
cmd.CommandText = "SELECT tp_id, tp_title, tp_assigned_to FROM
Projects;"
Set rs = cmd.execute
........
<select size="1" id="cdoProject" name="cdoProject"
onchange="javascript:getProject()">
<option value="SELECT">SELECT</option>
<%
Dim id, vProject
'EXECUTING- STORED QUERY- "SERVER_DROPDOWN"
Do until swss.EOF
id = swss.Fields("tp_id").value
vProject = swss.Field("tp_title").value
Response.Write "<option value=""" & vProject & """" & vProject &
"</option>"
swss.movenext
loop
swss.close
Set swss = Nothing
%>
</select>
<input type="button" value="Submit" name="btnSubmit"
onclick="Submit()">

Thanks in advance
Lisa
Jul 19 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
SelectedItem.Value
--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Lisa" <pe*****@yahoo.com> wrote in message
news:89**************************@posting.google.c om...
I know this is supposed to be easy but I can't get this to work. I
have a dropdown that pulls all the Projects (tp_title) available. All
I want to do is get the ID (tp_id) of that record so I can get the
developer assigned to that project (tp_assigned_to). Then, when I get
the developer, I need that to be redirected to a second page.

Example Code:
.....
function getProject(){
//I know that this gets the selected value of the dropdown
var cdoProject = document.frmSoftware.cdoProject.options[cdoProject.selectedIndex].value
//but how do I get tp_id to get tp_assigned_to?????

}
function Submit(){
document.frmSoftware.action =
"Process.asp?Developer=<%=Request.Form("XXX")% >";
document.frmSoftware.submit();
}
...
<form name="frmSoftware" method="post">
....

Set cmd.ActiveConnection = oConn
cmd.CommandText = "SELECT tp_id, tp_title, tp_assigned_to FROM
Projects;"
Set rs = cmd.execute
.......
<select size="1" id="cdoProject" name="cdoProject"
onchange="javascript:getProject()">
<option value="SELECT">SELECT</option>
<%
Dim id, vProject
'EXECUTING- STORED QUERY- "SERVER_DROPDOWN"
Do until swss.EOF
id = swss.Fields("tp_id").value
vProject = swss.Field("tp_title").value
Response.Write "<option value=""" & vProject & """" & vProject &
"</option>"
swss.movenext
loop
swss.close
Set swss = Nothing
%>
</select>
<input type="button" value="Submit" name="btnSubmit"
onclick="Submit()">

Thanks in advance
Lisa

Jul 19 '05 #2

P: n/a
Woops....sorry, was in .NET mode.

You are trying to get this in CLIENTside code so this isn't really the best
place but it should be something like
document.formname.cdoProject.value
At least I thought so.... I'd suggest hitting a clientside/javascript group
though

If I misread and you are trying ot get this serverside them just make sure
your dropdown uses the ID as the value and the NAME as the text for the
dropdown/select. Then just use Request.Form("cdoProject") to get the value.

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Lisa" <pe*****@yahoo.com> wrote in message
news:89**************************@posting.google.c om...
I know this is supposed to be easy but I can't get this to work. I
have a dropdown that pulls all the Projects (tp_title) available. All
I want to do is get the ID (tp_id) of that record so I can get the
developer assigned to that project (tp_assigned_to). Then, when I get
the developer, I need that to be redirected to a second page.

Example Code:
.....
function getProject(){
//I know that this gets the selected value of the dropdown
var cdoProject = document.frmSoftware.cdoProject.options[cdoProject.selectedIndex].value
//but how do I get tp_id to get tp_assigned_to?????

}
function Submit(){
document.frmSoftware.action =
"Process.asp?Developer=<%=Request.Form("XXX")% >";
document.frmSoftware.submit();
}
...
<form name="frmSoftware" method="post">
....

Set cmd.ActiveConnection = oConn
cmd.CommandText = "SELECT tp_id, tp_title, tp_assigned_to FROM
Projects;"
Set rs = cmd.execute
.......
<select size="1" id="cdoProject" name="cdoProject"
onchange="javascript:getProject()">
<option value="SELECT">SELECT</option>
<%
Dim id, vProject
'EXECUTING- STORED QUERY- "SERVER_DROPDOWN"
Do until swss.EOF
id = swss.Fields("tp_id").value
vProject = swss.Field("tp_title").value
Response.Write "<option value=""" & vProject & """" & vProject &
"</option>"
swss.movenext
loop
swss.close
Set swss = Nothing
%>
</select>
<input type="button" value="Submit" name="btnSubmit"
onclick="Submit()">

Thanks in advance
Lisa

Jul 19 '05 #3

P: n/a
Curt,
Yeah I tried that already and it didn't work the value of cdoProject
is blank- unless I have the syntax wrong?

function Submit(){
document.frmSoftware.action =
"Process.asp?Developer=<%=Request.Form("cdoProject ")%>";
document.frmSoftware.submit(); Set cmd.ActiveConnection = oConn
cmd.CommandText = "SELECT tp_id, tp_title, tp_assigned_to FROM
Projects;"
Set rs = cmd.execute
.......
<select size="1" id="cdoProject" name="cdoProject"
onchange="javascript:getProject()">
<option value="SELECT">SELECT</option>
<%
Dim id, vProject
'EXECUTING- STORED QUERY- "SERVER_DROPDOWN"
Do until swss.EOF
id = swss.Fields("tp_id").value
vProject = swss.Field("tp_title").value
Response.Write "<option value=""" & id & """" & vProject &
"</option>"
swss.movenext
loop
swss.close
Set swss = Nothing
%>
</select>

Jul 19 '05 #4

P: n/a
its your Select tag most likely...
do you have value attributes on each of the items in the select tag?

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"Lisa" <pe*****@yahoo.com> wrote in message
news:89**************************@posting.google.c om...
Curt,
Yeah I tried that already and it didn't work the value of cdoProject
is blank- unless I have the syntax wrong?

function Submit(){
document.frmSoftware.action =
"Process.asp?Developer=<%=Request.Form("cdoProject ")%>";
document.frmSoftware.submit(); Set cmd.ActiveConnection = oConn
cmd.CommandText = "SELECT tp_id, tp_title, tp_assigned_to FROM
Projects;"
Set rs = cmd.execute
.......
<select size="1" id="cdoProject" name="cdoProject"
onchange="javascript:getProject()">
<option value="SELECT">SELECT</option>
<%
Dim id, vProject
'EXECUTING- STORED QUERY- "SERVER_DROPDOWN"
Do until swss.EOF
id = swss.Fields("tp_id").value
vProject = swss.Field("tp_title").value
Response.Write "<option value=""" & id & """" & vProject &
"</option>"
swss.movenext
loop
swss.close
Set swss = Nothing
%>
</select>

Jul 19 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.