|
|
请问下面两行红色显示的代码有错误吗？
<!--#include file="config/conn.asp"-->
<%
area=request("area")
hangye=request("hangye")
zhineng=request("zhineng")
presstime=request("presstime")
corpname=request("corpname")
leibie=request("leibie")
%>
<%
set rs=server.CreateObject("adodb.recordset")
sql="select * from Job_Cleag inner join Job_Cleag_pressjob on Cleag_id=Job_id where job_flag=1"
if corpname<>" " then
if leibie="公司" then
sql=sql&"and Cleag_corpname like '%"&corpname&"%' "
else
if zhineng= " " then
sql=sql&" and Job_jobname like '%"&zhineng&"%' "
end if
end if
end if
if area<>" " then sql=sql&" and job_workplace='"&area&"' "
'if hangye<>" " then sql=sql&"and Job_jobdo='"&hangye&"' "
if zhineng<> " " then sql=sql&" and Job_jobdo='"&zhineng&"' "
if presstime<>" " then sql=sql& "and DateDiff('d',DateValue(Job_pressdate),DateValue(now()))='"&cint(presstime)&"' "
response.write sql
rs.open sql,conn,1,1 //此段显示错误
if rs.bof and rs.eof then
response.write "<script>alert('数据库中暂无您要的数据!');{window.location='index.asp'};</script>"
else
for i=1 to rs.recordcount
response.write "<br>"&(rs("Job_jobname"))
rs.movenext
next
end if
rs.close
set rs=nothing |
|
IP卡
狗仔卡
发表于 2010-1-14 01:18:23
收藏
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡