中科新闻网群等级头衔英文名称:asp中的查询有模糊查询吗?????快~~~怎么查........综合查询怎么查~~~~~~~~~~~~~~~~~
来源：百度文库 编辑：中科新闻网 时间：2024/05/04 05:58:19
if request.cookies("jd")("logid")=1 then
set rs=server.createobject("adodb.recordset")
if text2="gs" then
sel="select * from dd where gs ='"&text1&"'"
rs.open sel,conn,1,1
if rs.recordcount =0 then
Response.Write "您要查找的信息不存在，请重新输入!"
else
for i=1 to rs.recordcount%>
set rs=server.createobject("adodb.recordset")
if text2="gs" then
sel="select * from dd where gs ='"&text1&"'"
rs.open sel,conn,1,1
if rs.recordcount =0 then
Response.Write "您要查找的信息不存在，请重新输入!"
else
for i=1 to rs.recordcount%>
假如你要在stu表里查询姓李(name)的人
select * from stu where name like '李%'
like