大家帮我看看这串ASP的代码的错误!!谢谢!
大家帮我看看这串ASP的代码的错误!!谢谢!
<!--#include file="conn.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<script language="javascript">
<!--
function init(formname)
{
bdMvEvt= document.body.onmousemove;
bdUpEvt= document.body.onmouseup;
IMGPATH = 'http://images.51job.com/im/my/search';
form = document.getElementsByName(formname)[0];
buildDiv("popupArea");
buildGlobalDiv();
}
//-->
</script>
<script language="javascript" src="common.js"></script>
<script language="javascript" src="jobarea_array.js"></script>
<script language="javascript" src="jobarea_layer.js"></script>
</head>
<body onLoad="javascript:init('frmKeywordSearch');">
<form action="result.asp?Cityname=<%=Cityname%>" method="post" name="frmKeywordSearch" target="_blank" >
关键字<input name="keyword" id="keyword" type="text" value="" maxlength="180"/>
<input name="btnSltArea" id="btnSltArea" type="button" value="地区选择" onClick="hide();displayLayer('popupArea')"/>
<input type="hidden" name="jobarea" value=""/><input type="hidden" value="2" name="stype"/>
<input name=Submit type=submit class=checklist id="Submit" value=搜索>
</form>
<%
keyword=request("keyword")
btnSltArea=request("btnSltArea")
if keyword="" then
response.write "<script language=javascript>alert('查询内容不能为空!');history.back(-1);</script>"
response.end
end if
%>
<table width="90%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#FFFFCC"><%
Dim i
i=0
set rs = server.CreateObject("adodb.recordset")
sql="select CityName, Tiles from City order by ID desc"
rs.open sql,conn,1,1
if rs.eof then
response.write "对不起,暂时没有内容!"
else
do while not rs.eof
if request("btnSltArea")<>rs("CityName") then
i=1
else
i=2
end if
if i=2 then
asd= "Titles like '%"&keyWord&"%' "
end if
%>
<%
set rs2 = server.createobject("adodb.recordset")
sql2="select * from City where CityName="&CityName&" and "+asd+" order by id desc"
'response.write(sql2)
'response.End()
rs2.open sql2,conn,1,3
if rs2.eof then
response.write "对不起,暂时没有内容!"
else
%></td>
<td bgcolor="#FFFFCC"> 标题:<%=Tiles%> 城市:<%=CityName%></td>
</tr>
<tr>
<td width="37%" bgcolor="#FFFFCC">
<%
end if
rs2.close
set rs2=nothing
%></td>
<td width="63%" bgcolor="#FFFFCC"></td>
</tr>
<%
rs.movenext
loop
end if
rs.close
%>
</td>
</table>
</body>
</html>
调试运行的错误:
错误类型:
Microsoft JET Database Engine (0x80040E14)
语法错误 (操作符丢失) 在查询表达式 'CityName= and' 中。
/3/result.asp, 第 65 行