LongFeiFengWu
Technical User
The following set of scripts is used to pass information from a dropdown box to another ASP page in a querystring. For some reason, the values are not being carried to the next page and I can't figure out why. Any help will be greatly appreciated.
<script language="VBScript">
sub B1_onclick()
Name1 = theform.VZID.options(theform.VZID.selectedindex).text
VZID1 = theform.VZID.options(theform.VZID.selectedindex).value
location.href = "reviewsave.asp?Name="& Name1 &"&VZID="& VZID1 &""
end sub
</script>
<body>
<form method="POST" name="theform">
<table border="1" width="100%" cellspacing="0">
<tr>
<td width="23%" align="center"><select size="1" name="VZID">
<option value="NULL">Choose an Employee</option>
<%
SUPID1 = request.cookies("ECT")("SUPID")
SQL = "SELECT * FROM [Emp Data] "
SQL = SQL & "WHERE Status = 'Associate' "
SQL = SQL & "AND SUPID = '"& SUPID1 &"' "
SQL = SQL & "ORDER BY LastName"
objrec.open SQL,objcon,3,3
do while not objrec.eof
response.write "<option value='" & objrec("VZID") & "'>" & objrec("FirstName") & " " & objrec("LastName") & "</option>"
objrec.movenext
loop
'response.write SQL
%>
"If nothing within you stays rigid, outward things will disclose themselves. Moving, be like water. Still, be like a mirror. Respond like an echo." ~ Bruce Lee
<script language="VBScript">
sub B1_onclick()
Name1 = theform.VZID.options(theform.VZID.selectedindex).text
VZID1 = theform.VZID.options(theform.VZID.selectedindex).value
location.href = "reviewsave.asp?Name="& Name1 &"&VZID="& VZID1 &""
end sub
</script>
<body>
<form method="POST" name="theform">
<table border="1" width="100%" cellspacing="0">
<tr>
<td width="23%" align="center"><select size="1" name="VZID">
<option value="NULL">Choose an Employee</option>
<%
SUPID1 = request.cookies("ECT")("SUPID")
SQL = "SELECT * FROM [Emp Data] "
SQL = SQL & "WHERE Status = 'Associate' "
SQL = SQL & "AND SUPID = '"& SUPID1 &"' "
SQL = SQL & "ORDER BY LastName"
objrec.open SQL,objcon,3,3
do while not objrec.eof
response.write "<option value='" & objrec("VZID") & "'>" & objrec("FirstName") & " " & objrec("LastName") & "</option>"
objrec.movenext
loop
'response.write SQL
%>
"If nothing within you stays rigid, outward things will disclose themselves. Moving, be like water. Still, be like a mirror. Respond like an echo." ~ Bruce Lee