<%
var num = parseInt(Request.Form("T1"));
var casename = Request.Form("T2");
var caseurl = Request.Form("T3");
var flag = Request.Form("flag");
if(flag=""){

}
%>
……
<input type="hidden" name="flag" value="1">
……
<%else
if (num!=""){
sql = "Select * From case Where CaseNO="+num;
rs = Server.CreateObject("ADODB.Recordset");
rs = conn.Execute(sql);}//有错
else
if (casename!=""){
sql = "Select * From case Where CaseName='"+casename+"'";
rs = Server.CreateObject("ADODB.Recordset");
rs = conn.Execute(sql);}
else
if (caseurl!=""){
sql = "Select * From case Where CaseURL='"+caseurl+"'";
rs = Server.CreateObject("ADODB.Recordset");
rs = conn.Execute(sql);}

%>

<%

if(rs.eof){Response.Write("没有搜索到您需要的案例");}
else{
while(!rs.eof){

%>

<div align="center">
<center>
<table border="0" width="79%" height="64">
<tr>
<td width="100%" colspan="6" align="center" height="21"><b><font face="华文新魏" size="4">搜索结果显示</font></b></td>
</tr>
<tr>
<td width="17%" align="center" height="21"><font size="2"><b>案例时间</b></font></td>
<td width="15%" align="center" height="21"><font size="2"><b>案例编号</b></font></td>
<td width="32%" align="center" height="21"><font size="2"><b>案例名称</b></font></td>
<td width="30%" align="center" height="21"><font size="2"><b>案例URL</b></font></td>
<td width="8%" align="center" height="21"><b><font size="2">编辑</font></b></td>
<td width="8%" align="center" height="21"><b><font size="2">删除</font></b></td>
</tr>
<tr>
<td width="17%" align="center" height="8"><%=rs("CaseID")%></td>
<td width="15%" align="center" height="8"><%=rs("CaseNO")%></td>
<td width="32%" align="center" height="8"><%=rs("CaseName")%></td>
<td width="30%" align="center" height="8"><%=rs("CaseURL")%></td>
<td width="8%" align="center" height="8"><font size="2"><input type="submit" value="编辑" name="B1"></font></td>
<td width="8%" align="center" height="8"><font size="2"><input type="submit" value="删除" name="B2"></font></td>
</tr>
</table>
</center>
</div>
<%

rs.MoveNext();
}
}
rs.Close();

%>

</html>
这是个搜索，红色部分为出错行
出错信息为：
错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] 参数不足，期待是 1。
哪里错了？？？

直接就运行
if (num!="")
了
？？？？
应该是初始时var num = parseInt(Request.Form("T1"));
num为空呀？？
哪里错了呢

rs = conn.Execute(sql);}//有错
改成
rs.open sql, conn, 1, 3
试试

<%
if (num!=""){
sql = "Select * From case Where CaseNO="+num;
rs = Server.CreateObject("ADODB.Recordset");
rs = conn.Execute(sql);}
else
if (casename!=""){
sql = "Select * From case Where CaseName='"+casename+"'";
rs = Server.CreateObject("ADODB.Recordset");
rs = conn.Execute(sql);}
else
if (caseurl!=""){
sql = "Select * From case Where CaseURL='"+caseurl+"'";
rs = Server.CreateObject("ADODB.Recordset");
rs = conn.Execute(sql);}
else
if(num==""&&casename==""&&caseurl==""){
Response.Write("alert('输入!');");
Response.Write("window.location = 'admin_searchcase.asp';");
}
%>
现在问题红色部分根本运行不到??
我的语法有错么??
每次直接运行第一个:
sql = "Select * From case Where CaseNO="+num;
rs = Server.CreateObject("ADODB.Recordset");
rs = conn.Execute(sql);}
下面的都运行不到
只能查CaseNO??
为什么呢

三楼美女的写法也可以,是另一种连接数据库的方法
我是用jscript编的

回复四楼的！

你有多少个IF　结尾就有多少个END　IF　

去掉你的｛

ELSE
IF

改成ELSE　IF