易截截图软件、单文件、免安装、纯绿色、仅160KB

asp分页实例

<%
set rs=server.CreateObject("adodb.recordset")
ids=""
call lids(keys)
ids=keys&ids
sql="select id,title,pic_xiao,content from "&tables&" where lid in("&ids&") "

if request("keys_title")<>"" then
sql=sql&" and title like '%"&request("keys_title")&"%' "
end if
sql=sql&" order by shijian desc"
rs.open sql,conn,1,1
if rs.recordcount=0 then
Response.Write "产品整理中..."
else
rs.pagesize=12
page=clng(request.QueryString("page"))
if page<1 then page=1
if page>rs.pagecount then page=rs.pagecount
rs.absolutepage=page
j=0
for i = 1 to rs.pagesize
%>

<%
if page=1 then
response.Write("首页")
else
response.Write("<a href="?page=1&keys=" mce_href="?page=1&keys=""&keys&"&keys_title="&request("keys_title")&">首页</a>")
end if
if page=1 then
response.Write(" 上一页")
else
response.Write(" <a href="?page=" mce_href="?page="" & page-1 & "&keys="&keys&"&keys_title="&request("keys_title")&">上一页</a>")
end if
if page=rs.pagecount then
response.Write(" 下一页")
else
response.Write(" <a href="?page=" mce_href="?page="" & page+1 & "&keys="&keys&"&keys_title="&request("keys_title")&">下一页</a>")
end if
if page=rs.pagecount then
response.Write(&q


相关文档:

asp连接Mssql的方法及常见的错误

asp衔接Mssql的办法及常见的差错
//第一种写法:
MM_conn_STRING = "Driver={SQL Server};server=(local);uid=sa;pwd=;database=infs;"
Set conn = Server.Createobject("ADODB.Connection")
conn.open MM_conn_STRING
SET RS=SERVER.CreateObject("ADOBD.recordset")
SQL="SELECT * from TABLE ORDER BY ID DESC"
R ......

Asp常用通用函数之生成时间的整数

  '函数名:GetMyTimeNumber()
  '作 用:生成时间的整数
  '参 数:lx ---- 时间整数的类型
  ' lx=0 到分钟 lx=1 到小时 lx=2 到天 lx=3 到月
  '返回值:生成时间的整数值(最小到分钟)
  '示 例:
  '********************************* ......

asp伪静态代码

<%
DirName="html\" '静态文件保存的目录,结尾应带"\"
foxrax=Request("foxrax")
if foxrax="" then
FileName=GetStr()&".html"
FileName=replace(FileName,"/","")'替换字符
FileName=replace(FileName,"?","&qu ......

asp探针

<%@ Language="VBScript" %>
<%' Option Explicit %>
<%
'不使用输出缓冲区,直接将运行结果显示在客户端
Response.Buffer = False
'声明待检测数组
Dim ObjTotest(26,4)
ObjTotest(0,0) = "MSWC.AdRotator"
ObjTotest(1,0) = "MSWC.BrowserType"
ObjTotest(2,0) = ......

asp增加数据库表的字段代码

<%
'下面是最具技术含量的函数了,哈哈~
'增加数据库字段
function addziduan(ziduanming,ziduanleixing)
on error resume next
fldname = ziduanming
if ziduanleixing=1 or ziduanleixing=4 then
fldtype = "VarChar"
fldsize = 255
elseif ziduanleixing=2 or ziduanleixing=3 then
fldtyp ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号