当前记录集不支持书签问题
wha 2008-02-03 06:45:27 原先是mdb数据库,换为server2000后,源代码没变,语句为
dim bfs
dim Number,name
dim connect,rs
dim sql,xm,xh,nl,zz
Set conn=Server.CreateObject("ADODB.connection")
Set Rs = Server.CreateObject("ADODB.Recordset")
conn.open "PROVIDER=SQLOLEDB;DATA SOURCE=GYXX-Y95LIQJS70;UID=xinghe;PWD=xinghe;DATABASE=khgl"
xsmc=request.QueryString("xsmc")
cxtj=request.QueryString("cxtj")
if xsmc="" then
xsmc=session("xsmc")
cxtj=session("cxtj")
else
session("xsmc")=xsmc
session("cxtj")=cxtj
end if
tsxx=xsmc+"的企业如下,"
ssjb=session("ssjb")
if ssjb="部门经理" then
bm=cxtj
sql="select * from lxkhqk where ssbm='"& cxtj &"' and ssdq='"&xsmc &"' order by id desc"
end if
if ssjb="业务员" then
bm=cxtj
ywyxm=session("user_xm")
sql="select * from lxkhqk where ywyxm='"& ywyxm &"' and ssdq='"&xsmc &"' order by id desc"
end if
if ssjb="管理员" then
ywydm=session("user_id")
sql="select * from lxkhqk where ssdq='"&xsmc &"' order by id desc"
end if
bm=bm+"联系"
set rs=server.createobject("adodb.recordset")
rs.cursorlocation = 3
rs.open sql,conn,1,1
if rs.eof then
response.Write "客户未找到!"
response.end
end if
rs.PageSize=20
zys=rs.PageCount
zjls=rs.RecordCount
if Request.QueryString("pagenum")="" then
pagenum=1
else
pagenum=Request.QueryString("pagenum")
if pagenum=rs.PageCount+1 then
pagenum=rs.PageCount
end if
if pagenum<1 then
pagenum=1
end if
end if
rs.AbsolutePage =pagenum在需要分页是出现错误,环境为win2003+iis6.0。请诸位大侠帮忙!谢谢!!