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" <peashoe@yahoo.com> wrote in message
news:8949b7ca.0407220550.3618614e@posting.google.c om...[color=blue]
> 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 =[/color]
document.frmSoftware.cdoProject.options[cdoProject.selectedIndex].value[color=blue]
>
> //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[/color]