Answered
jump menu from database
I’m trying to create a “jump menu” from a
database table.
I’ve created the jump menu by using a "List/Menu" and a "Dynamic" connection, this displays the items correctly.
Next I’ve used “Go To URL” and set the parameters for the page load to use the value of the List/Menu to load the required webpage and oppropriate value.
The page loads however it doesn’t show (or use) the value from the List/Menu
Any ideas?
Heres my code
<select name="selPRINT" id="selPRINT" onChange="MM_goToURL('parent','conPROD.asp?REF=<%=cStr(Request.Form("selPRINT"))%>');return document.MM_returnValue">
<option value="">Select your printer...</option>
<%
While (NOT rsPRODUCT.EOF)
%>
<option value="<%=(rsPRODUCT.Fields.Item("printDELLref").Value)%>"><%=(rsPRODUCT.Fields.Item("printPRODUCT").Value)%></option>
<%
rsPRODUCT.MoveNext()
Wend
If (rsPRODUCT.CursorType > 0) Then
rsPRODUCT.MoveFirst
Else
rsPRODUCT.Requery
End If
%>
</select>
I’ve created the jump menu by using a "List/Menu" and a "Dynamic" connection, this displays the items correctly.
Next I’ve used “Go To URL” and set the parameters for the page load to use the value of the List/Menu to load the required webpage and oppropriate value.
The page loads however it doesn’t show (or use) the value from the List/Menu
Any ideas?
Heres my code
<select name="selPRINT" id="selPRINT" onChange="MM_goToURL('parent','conPROD.asp?REF=<%=cStr(Request.Form("selPRINT"))%>');return document.MM_returnValue">
<option value="">Select your printer...</option>
<%
While (NOT rsPRODUCT.EOF)
%>
<option value="<%=(rsPRODUCT.Fields.Item("printDELLref").Value)%>"><%=(rsPRODUCT.Fields.Item("printPRODUCT").Value)%></option>
<%
rsPRODUCT.MoveNext()
Wend
If (rsPRODUCT.CursorType > 0) Then
rsPRODUCT.MoveFirst
Else
rsPRODUCT.Requery
End If
%>
</select>
AdChoices