自学汽修大全软件下载:求救求救!ASP代码问题!大家帮帮忙看看~~

来源:百度文库 编辑:查人人中国名人网 时间:2024/03/29 08:07:38
<%
dim totaluser,page,pages,i,suser,sname,ter_id,cla_id,sql_suser,sql_sname,sql_ter_id,sql_cla_id
set rs= Server.CreateObject("ADODB.Recordset")
suser=request("suser")
sname=replace(trim(request("sname")),"'","")
ter_id=request("ter_id")
cla_id=request("cla_id")
if isnumeric(suser)=false then
sql_suser=""
else
sql_suser=" and s.suser='"&suser&"' "
end if
if sname="" then
sql_sname=""
else
sql_sname=" and s.sname='"&sname&"' "
end if
if tnow<>"" then
if ter_id="" then
sql_ter_id=" and s.ter_id="&tnow&" "
elseif ter_id="all" then
sql_ter_id=""
else
sql_ter_id=" and s.ter_id="&ter_id&" "
end if
end if
if cla_id="" then
sql_cla_id=""
else
sql_cla_id=" and s.cla_id="&cla_id&" "
end if
171-> rs.open ("select s.sid,s.suser,s.sname,s.khdz,s.states,c.cname,t.tname,d.dname from student s,class c,term t,department d where c.dep_id=d.did and s.cla_id=c.cid and s.ter_id=t.tid s.suser like '%"&sql_suser&"%' "&sql_sname&" "&sql_ter_id&" "&sql_cla_id&" order by s.sid desc"),conn,1,1

Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21'
ODBC 驱动程序不支持所需的属性。

/admin_useradmin.asp,行 171

简单说下!我想搞个查询页面!多项的!但是suser这个字符段希望实现模糊查询!那: rs.open ("select s.sid,s.suser,s.sname,s.khdz,s.states,c.cname,t.tname,d.dname from student s,class c,term t,department d where c.dep_id=d.did and s.cla_id=c.cid and s.ter_id=t.tid s.suser like '%"&sql_suser&"%' "&sql_sname&" "&sql_ter_id&" "&sql_cla_id&" order by s.sid desc"),conn,1,1
出错在那里呢!
感谢blackstar_st朋友的回答!但是我找了半天还是没有发现原因!我把我没修改前的那段发上来!希望您能帮我检查下!不胜感激!

rs.open ("select s.sid,s.suser,s.sname,s.khdz,s.states,c.cname,t.tname,d.dname from student s,class c,term t,department d where c.dep_id=d.did and s.cla_id=c.cid and s.ter_id=t.tid "&sql_suser&" "&sql_sname&" "&sql_ter_id&" "&sql_cla_id&" order by s.sid desc"),conn,1,1
这是原先的!这样运行就没有出错哦!

rs.open (\"select s.sid,s.suser,s.sname,s.khdz,s.states,c.cname,t.tname,d.dname from student as s,class as c,term as t,department as d where c.dep_id=d.did and s.cla_id=c.cid and s.ter_id=t.tid s.suser like \'%\"&sql_suser&\"%\' \"&sql_sname&\" \"&sql_ter_id&\" \"&sql_cla_id&\" order by s.sid desc\"),conn,1,1