UC知道又是关于ASP查找功能的问题，，，查找高手~~~~
来源：百度知道 编辑：UC知道 时间：2024/05/25 14:09:08
<%
if Trim(Request("v_name"))="" and Trim(Request("v_user"))="" then
response.redirect"admin.asp"
end if
if Trim(Request("v_name"))<>"" and Trim(Request("v_user"))<>"" then
dim vrs,vsql
set vrs=Server.CreateObject("ADODB.Recordset")
vsql="Select*From student Where s_name='%"& Trim(Request("v_name"))&"%'and&s_user='%"& Trim(Request("v_name"))&"%'"
vrs.Open vsql,connstr,1,1
if vrs.recordCount<=0 then
response.write"对不起，没有找到相关信息！"
else
response.write"共找到"&vrs.recordCount&"条记录"
%>
如果就一个Trim(Request("v_name"))<>""就行啦，，，但二个参数就不行了求高手指点~
if Trim(Request("v_name"))="" and Trim(Request("v_user"))="" then
response.redirect"admin.asp"
end if
if Trim(Request("v_name"))<>"" and Trim(Request("v_user"))<>"" then
dim vrs,vsql
set vrs=Server.CreateObject("ADODB.Recordset")
vsql="Select*From student Where s_name='%"& Trim(Request("v_name"))&"%'and&s_user='%"& Trim(Request("v_name"))&"%'"
vrs.Open vsql,connstr,1,1
if vrs.recordCount<=0 then
response.write"对不起，没有找到相关信息！"
else
response.write"共找到"&vrs.recordCount&"条记录"
%>
如果就一个Trim(Request("v_name"))<>""就行啦，，，但二个参数就不行了求高手指点~
将:
vsql="Select*From student Where s_name='%"& Trim(Request("v_name"))&"%'and&s_user='%"& Trim(Request("v_name"))&"%'"
改成:
vsql="Select*From student Where s_name='%" & Trim(Request("v_name"))& "%'and s_user='%" & Trim(Request("v_name")) & "%'"
把if Trim(Request("v_name"))="" and Trim(Request("v_user"))="" then
改成if Trim(Request("v_name"))="" or Trim(Request("v_user"))="" then
看看
vsql="Select*From student Where 1=1"
if Trim(Request("v_name"))<>"" then
vsql=vsql&" and s_name='%"& Trim(Request("v_name"))&"%'"
end if
if Trim(Request("v_user"))<>"" then
vsql=vsql&" and s_user='%"& Trim(R