来看看小弟代码有什么错,自动查询的问题。
我想在这个页面输入阀门编号就自动查出阀门地址,怎么老是查不到????我有两个页面,是第而个写错了吗?该怎么改,谢了哈!!!
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft FrontPage 4.0">
<TITLE>输入启闭的阀门编号和地址</TITLE>
<style>
.labelStyle
{font-family:宋体;
font-size:12;
font-color:#6495ED;
text-align:left
}
.textStyle
{font-family:宋体;
font-size:12;
font-color:#6495ED;
text-align:right
}
</style>
<base target="right">
</HEAD>
<BODY bgcolor="#E9967A" topmargin="0" leftmargin="0"><P> <br>
<!--<form action=fmcx.asp method=post name=query target=_top>-->
<table align=center border="0" width="100%" height="70%" bgcolor="#E9967A" class=labelstyle valign=center >
<tr height=20%>
<td class=textstyle>阀门编号:</td>
<td><input name=fm type=text class=labelstyle size=7 maxlength=7>
</tr>
<tr height=45%>
<td class=textstyle>阀门地址:</td>
<td><textarea id=dz class=labelstyle cols=26 rows=2></textarea>
<input type=button name=xc value=…></td>
</tr>
<tr height=35%>
<td colspan=2 align=center valign=bottom>
<input type=button name=ok value=确定>
<input type=button name=no value=取消>
</td>
</tr>
</table>
<!--</form>-->
</BODY>
</HTML>
<script language=vbscript>
sub xc_onclick()
window.open "fm_find.asp?fm_bh="&trim(document.all("fm").value),"right"
end sub
sub ok_onclick()
if len(trim(document.all("fm").value))<>7 and trim(document.all("fm").value)<>"无" then
msgbox "数据填写有误!"
exit sub
end if
if trim(document.all("dz").value)="" then
msgbox "数据填写有误!"
exit sub
end if
document.all("fm").value=ucase(document.all("fm").value)
qbfmdz=replace(document.all("dz").value,"#","#")
window.close
returnvalue=document.all("fm").value&"|"&qbfmdz
end sub
sub no_onclick()
window.close
returnvalue=""
end sub
</script>
<%@ Language=VBScript %>
<%set rc=server.CreateObject("adodb.recordset")
fm_bh=Request.QueryString("fm_bh")
rc.Open "select fg_dz from Valve_Current_Total where fm_bh='"&fm_bh&"'",session("connection_string"),3,3
if rc.RecordCount>0 then
fm_dz=rc(0)
else
fm_dz=""
end if
set rc=nothing
%>
<script language=jscript>
fm_dz="<%=fm_dz%>"
if(fm_dz==""){
alert("阀门未找到!请检查阀门编号是否正确!")
window.parent.frames("left").dz.value=""
}
else
{
window.parent.frames("left").dz.value=fm_dz
}
</script>