获取不到正确的值
<!--#include file= "../dbconn2.asp "-->
<!--#include file= "safe.asp "-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN " "http://www.w3.org/TR/html4/loose.dtd ">
<html>
<head>
<meta http-equiv= "Content-Type " content= "text/html; charset=gb2312 ">
<title> 员工档案___修改记录 </title>
<LINK href= "../images/style.css " rel=stylesheet>
<script src= "../inc/common.js?t=20050304 " type= "text/javascript "> </script>
<%
if Chkrequest(request( "id ")) then
id=request( "id ")
else
response.end
end if
sql= "select * from worker where id= "&id& " "
Set rs= conn.execute(sql)
if rs.eof then
response.Redirect( "editworker.asp ")
response.end
else
%>
<script language= "JavaScript ">
<!--
function namosw_goto(url, targetstr)
{
if (url == 'backward ')
history.back(1);
else if (url == 'forward ')
history.forward(1);
else {
if (targetstr == 'blank ') {
window.open(url, 'win1 ');
} else {
var frameobj;
if ((frameobj = eval(targetstr)) != null)
frameobj.location = url;
}
}
}
// -->
</script>
<SCRIPT language=JavaScript>
function setSubjectText(){
if(trim(document.form.worker.value) == " ") {
alert( "请填写员工姓名 ");
document.form.worker.focus();
return false;
}
if(trim(document.form.workid.value) == " ") {
alert( "请先选择部门 ");
document.form.workid.focus();
return false;
}
if(trim(document.form.typeid.value) == " ") {
alert( "请先选择职务 ");
document.form.typeid.focus();
return false;
}
// return true;
document.form.submit()
}
function trim(inputString) {
if (typeof inputString != "string ") { return inputString; }
var retValue = inputString;
var ch = retValue.substring(0, 1);
while (ch == " ") {
//检查字符串开始部分的空格
retValue = retValue.substring(1, retValue.length);
ch = retValue.substring(0, 1);
}
ch = retValue.substring(retValue.length-1, retValue.length);
while (ch == " ") {
//检查字符串结束部分的空格
retValue = retValue.substring(0, retValue.length-1);
ch = retValue.substring(retValue.length-1, retValue.length);
}
while (retValue.indexOf( " ") != -1) {
//将文字中间多个相连的空格变为一个空格
retValue = retValue.substring(0, retValue.indexOf( " ")) + retValue.substring(retValue.indexOf( " ")+1, retValue.length);
}
return retValue;
}
</SCRIPT>
<script language = "JavaScript ">
sall=new Array();
<%
Dim i
i=0
set rs0=conn.execute( "select * from workclasspart ")
do while not rs0.eof
%>
sall[ <%=i%> ]=new Array( " <%=rs0( "typename ")%> ", " <%=rs0( "workid ")%> ", " <%=rs0( "typeid ")%> ");
<%
i=i+1
rs0.movenext
loop
rs0.close
set rs0=nothing
%>
function changeselect(selvalue)
{
document.form.typeid.length=0;
var selvalue=selvalue;
var i;
for(i=0;i <sall.length;i++)
{
if(sall[i][1]==selvalue)
{
var newOption1=new Option(sall[i][0],sall[i][2]);
document.all.typeid.add(newOption1);
}
}
}
</script>
<script language = "JavaScript ">
sall1=new Array();
<%
Dim ii
ii=0
set rs4=conn.execute( "select * from village ")
do while not rs4.eof
%>
sall1[ <%=ii%> ]=new Array( " <%=rs4( "village ")%> ", " <%=rs4( "townid ")%> ", " <%=rs4( "villageid ")%> ");
<%
ii=ii+1
rs4.movenext
loop
rs4.close
set rs4=nothing
%>
function changeselect1(selvalue)
{
document.form.villageid.length=0;
var selvalue=selvalue;
var ii;
for(ii=0;ii <sall1.length;ii++)
{
if(sall1[ii][1]==selvalue)
{
var newOption1=new Option(sall1[ii][0],sall1[ii][2]);
document.all.villageid.add(newOption1);
}
}
}
</script>
</head>
<body leftmargin= "0 " bottommargin= "0 " rightmargin= "0 " topmargin= "0 " marginheight= "0 " marginwidth= "0 " bgcolor= "#DDEEFF "> <center> <br> <br>
<form method= "post " action= "save_editworker.asp " name= "form " enctype= "multipart/form-data ">
<input type= "hidden " name= "id " value= " <%=id%> ">
<table width= "750 " border= "0 " cellspacing= "0 " cellpadding= "0 ">
<tr>
<td width= "190 " colspan= "2 " align=left> 〓 <b> 基本资料 </b> 〓 </td>
<td width= "60 "> </td>
<td align=left> </td>
<td width= "82 "> </td>
<td width= "119 " align=left> </td>
<td rowspan= "5 " width=150 id= "previewImage " valign= "middle " align= "center " style= "width:100px;height:120px;border:solid 1px #DDD ">
<img name= "pic " src= "/oa/photo/ <%=rs( "photo ")%> " width= "100 " height= "120 " onload= "ResizeImage(this, 100, 120); " />
</td>
</tr>
<tr>
<td width= "68 "> 员工姓名： </td>
<td width= "122 " align=left> <INPUT maxLength=15 size=12 name=worker value= ' <%=rs( "worker ")%> '> </td>
<td width= "60 "> 员工类别： </td>
<td align=left>
<select name= "workid " onChange= "changeselect(document.form.workid.options[document.form.workid.selectedIndex].value) " size= "1 ">
<%
set rs1=conn.execute( "select * from workclass ")
do while not rs1.eof
'这儿可以获取正确的值
response.write " <option value= ' "&rs1( "workid ")& " ' "%> <%if (rs1( "workid ")=rs( "workid ")) then response.write "selected " end if%> <% response.write "> "&rs1( "workclass ")& " </option> "&chr(13)+chr(10)
rs1.movenext
loop
rs1.close
%>
</select>
</td>
<td width= "82 "> 员工职位： </td>
<td width= "119 " align=left> <select name= "typeid ">
<%
set rs2=conn.execute( "select * from workclasspart where workid= "&rs( "workid ")& " ")
do while not rs2.eof
'这儿可以获取正确的值
response.write " <option value= ' "&rs2( "typeid ")& " ' "%> <%if (rs2( "typeid ")=rs( "typeid ")) then response.write "selected " end if%> <% response.write "> "&rs2( "typename ")& " </option> "&chr(13)+chr(10)
rs2.movenext
loop
rs2.close
%>
</select>
</td> </tr>
<tr>
<td> 联系手机： </td>
<td align= "left "> <INPUT maxLength=15 size=12 name=mobile value= ' <%=rs( "mobile ")%> '> </td>
<td> 固定电话： </td>
<td align= "left "> <INPUT maxLength=15 size=12 name=tel value= ' <%=rs( "tel ")%> '> </td>
<td> 工号： </td>
<td> <INPUT maxLength=20 size=15 name=no value= ' <%=rs( "no ")%> '> </td>
</tr>
<tr>
<td> 紧急电话： </td>
<td align= "left "> <INPUT maxLength=15 size=12 name=jinji value= ' <%=rs( "jinji ")%> '> </td>
<td> 及时通讯： </td>
<td align= "left "> <INPUT maxLength=15 size=12 name=contact value= ' <%=rs( "contact ")%> '> </td>
<td> 紧急电话： </td>
<td> <INPUT maxLength=20 size=15 name=fax value= ' <%=rs( "fax ")%> '> </td>
</tr>
<tr>
<td> E-mail： </td>
<td align=left> <INPUT maxLength=30 size=15 name=email value= ' <%=rs( "email ")%> '> </td>
<td> 职位状态： </td>
<td align=left> <select NAME= "active ">
<option VALUE= "1 " <%if rs( "active ")=1 then%> selected <%end if%> > 试用 </option>
<option VALUE= "2 " <%if rs( "active ")=2 then%> selected <%end if%> > 在职 </option>
<option VALUE= "3 " <%if rs( "active ")=3 then%> selected <%end if%> > 离职 </option>
</select> </td>
<td> 入职日期： </td>
<td align=left> <INPUT maxLength=15 size=12 name=jointime value= ' <%=rs( "jointime ")%> '> </td>
</tr>
<tr>
<td rowspan= "2 "> 身份证ID： </td>
<td align=left rowspan= "2 "> <INPUT maxLength=18 size=18 name=pid value= ' <%=rs( "pid ")%> '> </td>
<td align=left rowspan= "2 "> 生日： </td>
<td align=left rowspan= "2 "> <INPUT maxLength=15 size=12 name=birth value= ' <%=rs( "birth ")%> '> </td>
<td rowspan= "2 "> 离职日期： </td>
<td align=left rowspan= "2 "> <INPUT maxLength=15 size=12 name=lefttime value= ' <%=rs( "lefttime ")%> '> </td>
</tr>
<tr>
<td width=150> <input type= "file " size= "10 " name= "file " onchange= "document.getElementById( 'previewImage ').innerHTML = ' <img src=\ ' '+this.value+ '\ ' width=100 height=120 onload=\ 'ResizeImage(this, 100, 120);\ ' align=absmiddle> '; " />
</td>
</tr> </table>
[解决办法]
<%if cstr(trim(rs5( "townid ")))=cstr(trim(rs( "townid "))) then%>
[解决办法]
Response.Write rs5( "townid ") & " = " & rs( "townid ")看看有没有相等的数据?
有的话,试试看
if CInt(rs5( "townid ").Value) = CInt(rs( "townid ").Value) then