hi,
i wants to create the multiselect dependable list, for that i used 4 list boxes here is my coding
<%@ page import="javax.sql.*" %>
<%@ page import="java.sql.*" %>
<%! String t="";%>
<%int count = 0;
ResultSet rs1=null;ResultSet rs2=null;ResultSet rs3=null;ResultSet rs4=null;ResultSet rs5=null;
Statement stmt1=null;
Connection con1=null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con1 = DriverManager.getConnection("jdbc:odbc:elog","guest","guest");
stmt1 = con1.createStatement();
rs1= stmt1.executeQuery("select Shift_desc from tbshift");
}
catch(Exception e)
{
}%>
<script language="JavaScript">
<!--
function shiftop()
{
var tt=(document.main1.shift.options[document.main1.shift.selectedIndex].value);
if(document.main1.shift.options.selectedIndex!=0)
{
<% String sop="<script>document.writeln(tt)</script>";%>
var k="<%=sop%>";
var s="<%=sop%>";
option1 =new Option(s,k);
document.main1.team.options.length=0;
document.main1.team.options[0]=option1;
}
else
{
document.main1.team.options.length=0;
}
}
// -->
</script>
<html>
<head>
<title>::: Medical Transcription :::</title>
</head>
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<form name="main1">
<p> </p>
<p> </p>
<table border="0" cellspacing="0" cellpadding="00" width="100%">
<tr>
<td width="13%">
<table border="0" cellspacing="0" cellpadding="00" width="28%">
<tr>
<td width="8%"><img src="images/top_left_cr1.gif" width="111" height="127"></td>
<td width="9%"><img src="images/top_left_cr2.gif" width="123" height="127"></td>
<td width="8%"><img src="images/top_center.gif" width="113" height="127"></td>
<td width="8%"><img src="images/top_right_cr2.gif" width="115" height="127"></td>
<td width="0%"><img src="images/top_right_cr1.gif" width="118" height="127"></td>
</tr>
<tr>
<td width="8%"><img src="images/bot_left_cr1.gif" width="111" height="133"></td>
<td width="9%"><img src="images/bot_left_cr2.gif" width="123" height="133"></td>
<td width="8%"><img src="images/bot_center.gif" width="113" height="133"></td>
<td width="10%"><img src="images/bot_right_cr2.gif" width="115" height="133"></td>
<td width="10%"><img src="images/bot_right_cr1.gif" width="118" height="133"></td>
</tr>
</table>
</td>
<td width="87%" background="images/bg.gif" valign="middle"> <br><br><br>
</td>
</tr>
</table>
<div id="Layer1" style="position:absolute; width:200px; height:115px; z-index:1; left: 244px; top: 164px">
<table width="100%" border="0" cellspacing="0" cellpadding="00">
<tr>
<td>SHIFT</td>
<td> </td>
<td>TEAM</td>
<td> </td>
<td>USERTYPE</td>
<td> </td>
<td>WORKPOOL</td>
<td> </td>
<td>USERID</td>
</tr>
<tr>
<td>
<select name="shift" multiple OnChange="shiftop()" size="5" >
<option>ALL</option></option>
<%
while (rs1.next())
{
t=rs1.getString("Shift_desc");
%>
<option value="<%=t%>"> <%=t%> </option>
<%}
%>
</select>
</td>
<td> </td>
<td>
<select name="team" multiple size="5">
<option> ALL</option>
<%
rs2=stmt1.executeQuery("select team_desc from tbteam");
while (rs2.next())
{
t=rs2.getString("team_desc");
%>
<option value="<%=t%>"> <%=t%> </option>
<%}
%>
</select>
</td>
<td> </td>
<td>
</select>
</td>
<td> </td>
<td>
<select name="userID" multiple size="5">
<option> ALL</option>
<% rs5=stmt1.executeQuery("select cduserid from tbuserid");
while (rs5.next())
{
t=rs5.getString("cduserid");
%>
<option value="<%=t%>"> <%=t%> </option>
<%}
%>
</select>
</td>
</tr>
<tr>
<td> </td>
</tr>
</table>
</div>
</form>
</body>
</html>
the <% String sop="<script>document.writeln(tt)</script>";%> statement executes well in external progarams when i exevute like this it just give me the output as it is in the "".