dw中根据下拉列表/菜单和文本框条件实现查询 15
1个回答
2015-04-05
展开全部
查询代码:<%
KeyWord = DelStr(Request("KeyWord"))
If KeyWord="" Then
sql="Select * From Net_Express order by NID Desc"
Else
sql="Select * From Net_Express Where FormDate like '%"& KeyWord &"%' or ToName like '%"& keyWord &"%' or diqu like '%"& keyWord &"%' or jiehuoren like '%"& keyWord &"%' or NNO like '%"& KeyWord &"%' or FormName like '%"& KeyWord &"%' or FormTel like '%"& KeyWord &"%' or diqu like '%"& KeyWord &"%' order by diqu asc,ToName asc"
End If
set rs=createobject("adodb.recordset")
rs.open sql,conn,1,3
rs.pagesize=16
if not rs.eof and not rs.bof then
%>
KeyWord = DelStr(Request("KeyWord"))
If KeyWord="" Then
sql="Select * From Net_Express order by NID Desc"
Else
sql="Select * From Net_Express Where FormDate like '%"& KeyWord &"%' or ToName like '%"& keyWord &"%' or diqu like '%"& keyWord &"%' or jiehuoren like '%"& keyWord &"%' or NNO like '%"& KeyWord &"%' or FormName like '%"& KeyWord &"%' or FormTel like '%"& KeyWord &"%' or diqu like '%"& KeyWord &"%' order by diqu asc,ToName asc"
End If
set rs=createobject("adodb.recordset")
rs.open sql,conn,1,3
rs.pagesize=16
if not rs.eof and not rs.bof then
%>
本回答被网友采纳
已赞过
已踩过<
评论
收起
你对这个回答的评价是?
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询