I have a drop down box that is populated with P/N's from a D/B each P/N has it own URL in the D/B. I want the user to select a part number and the bottom frame to load the Url associated with the P/N. I can populate the drop down box no problem but can not get it to redirect. Here some code:
<cfquery name="Get_PartNumbers" datasource="ewi" dbtype="ODBC">
Select PN, Location
From Directory
Order by PN
</cfquery>
<SCRIPT LANGUAGE="JavaScript">
<!-- JavaScript begins...
function jump (page) {
//alert(page);
window.location = page;
}
// JavaScript ends -->
</SCRIPT>
</HEAD>
<BODY>
<TABLE Width="100%" cellspacing="2" cellpadding="2" border="0" background="images/Back_a.gif" >
<TR>
<TD><IMG height=92 alt="" src="images/logo-corp.gif" width=144 border=0></TD>
<td align="Left" valign="bottom">Select Part Number
<SELECT NAME="page" onChange = Location>
<CFOUTPUT query="Get_PartNumbers">
<OPTION value=#PN# selected> #PN# </OPTION>
</CFOUTPUT>
</SELECT>
</TD>
<cfquery name="Get_PartNumbers" datasource="ewi" dbtype="ODBC">
Select PN, Location
From Directory
Order by PN
</cfquery>
<SCRIPT LANGUAGE="JavaScript">
<!-- JavaScript begins...
function jump (page) {
//alert(page);
window.location = page;
}
// JavaScript ends -->
</SCRIPT>
</HEAD>
<BODY>
<TABLE Width="100%" cellspacing="2" cellpadding="2" border="0" background="images/Back_a.gif" >
<TR>
<TD><IMG height=92 alt="" src="images/logo-corp.gif" width=144 border=0></TD>
<td align="Left" valign="bottom">Select Part Number
<SELECT NAME="page" onChange = Location>
<CFOUTPUT query="Get_PartNumbers">
<OPTION value=#PN# selected> #PN# </OPTION>
</CFOUTPUT>
</SELECT>
</TD>