jump menu from database

[BlueJC]

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>

[BlueJC · Accepted solution]

I have the answer.

First I created a list/menu and associated my database item to it.
Next I created a jump-menu.
I then used the database code from the list/menu and inserted it into the jump-menu.
Finally I added the option value of the page I wanted to load.

Here’s my final code…

<select name="jumpMenu" class="SmallBLACK" id="jumpMenu" onChange="MM_jumpMenu('parent',this,0)">
<option value="conPROD.asp?REF=<%=(rsP.Fields.Item("printDELLref").Value)%>">Select your printer....</option>
<%
While (NOT rsP.EOF)
%>
<option value="conPRINTdetail.asp?REF=<%=(rsP.Fields.Item("printDELLref").Value)%>"><%=(rsP.Fields.Item("printPRODUCT").Value)%></option>
<%
rsP.MoveNext()
Wend
If (rsP.CursorType > 0) Then
rsP.MoveFirst
Else
rsP.Requery
End If
%>
</select>