郁闷了一天~~总觉得没什么错误~~大家帮我看看,急~~
91jk 2004-12-25 08:53:14 我做了个搜索,数据库中有数据,我按照条件搜索,但是怎么老是有“没有符合您要求的记录”的提示啊?帮我看看啊`~~~
<%dim dbpath,rs,conn
dim fdkemu,mqcd,xssex,price,sql,pre,str
fdkemu=request("fdkemu")
mqcd=request("mqcd")
xssex=request("xssex")
price=request("price")
DbPath = SERVER.MapPath("../cnm/wuzifengloverongrong.mdb")
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DbPath
Set rs = Server.CreateObject("ADODB.Recordset")
'///////////////////////////////////////////////////////////////////////////////// 取得线路信息
if fdkemu=""and mqcd="" and xssex="" and price="" then
response.write"<script language='javascript'>"
response.write"alert('至少应该有一个查询条件!');"
response.write"history.go(-1);"
response.write"</script>"
response.end
else
sql="select fdkemu,mqcd,xssex,price from student where (id is null)"
if fdkemu<>"" then
sql=sql&"and fdkemu like '%"&fdkemu&"%' "
end if
if mqcd<>"" then
sql=sql&"and mqcd like '%"&mqcd&"%' "
end if
if xssex<>"" then
sql=sql&"and xssex like '%"&xssex&"%' "
end if
if price<>"" then
sql=sql&"and price like '%"&price&"%' "
end if
rs.open sql,conn,3,2
if rs.eof or rs.bof then
response.write"<script language='javascript'>"
response.write"alert('没有符合您要求的记录!');"
response.write"history.go(-1);"
response.write"</script>"
response.end
end if
end if
%>