/soucl.asp代码页
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%><?xml version="1.0" encoding="utf-8"?>
<%response.buffer=true%>
<%Response.ContentType = "text/vnd.wap.wml; charset=utf-8"%>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN" "http://www.wapforum.org/DTD/wml_1.1.xml"> 
<!--#include file="conn.inc"-->
<wml>
<head>
<meta http-equiv='Cache-Control' content='no-cache'/>
</head>
<%
'---接收数据----
mmbb=usb(request("mmbb"))
if mmbb="" then mmbb="txt"
pp=request.QueryString("pp")
ltid=request.QueryString("ltid")

title=(Request("title"))
	IF title<>"" then
	'---结束接收----
	%>
<card id="index" title="搜索结果"><p>
<%set brs=Server.CreateObject("ADODB.Recordset")
ssql="select * from [wap_lm] where "&mmbb&" like '%"&title&"%'"
brs.open ssql,conn,1,1
if brs.eof then
   Response.write "没有您要找的内容<br/>"
Else
Response.write "共找到相关内容"&brs.RecordCount&"个<br/>"
page=cint(request("page"))
if page="" or page<1 then page=1
maxpage=int((brs.recordcount-1)/15)+1
if page>maxpage then page=maxpage

brs.Move((page-1)*15)
dim j
j=1
do while ((not brs.EOF) and j <=cint(15))
    spmc=left(brs("nxn"),8)
   if len(brs("nxn"))>8 then
    spmc=spmc+"。。"
   End if
    Response.write ""&(j+page*15)-15&".<a href='view.asp?id=" & brs("id") & "&amp;page="&page&"'>" & ubb(spmc) & "</a><br/>"
brs.Movenext  
j=j+1
loop

if page*15<brs.recordcount then response.write("[<a href='soucl.asp?title=" & title & "&amp;page=" & page+1 & "'>下一页</a>]")
if page>1 then response.write("[<a href='soucl.asp?title=" & title & "&amp;page=" & page-1 & "'>上一页</a>]")

		if bRs.PageCount>2 then%>
		<br/><input name="Page" format="*N" size="3"/>
		<anchor>跳页
		<go href="soucl.asp?ltid=<%=ltid%>&amp;glsb=<%=glsb%>" method="post">
        	<postfield name="Page" value="$(Page)"/>
        	<postfield name="title" value="$(title)"/>
    		</go>
		</anchor>共[<%=Page%>/<%=maxpage%>]页
		<%end if
end if
brs.close
set brs=nothing
else%>
<card id="index" title="出错了"><p>
搜索内容不能为空。<br/>
<%end if%>
<%
conn.close
set conn=nothing%>
<!--#include file="w.asp"-->
</p></card>
</wml>
相关源码
字母检索
回到顶部