查询代码:<%
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
%>