作者Phizek ()
看板Programming
标题[问题] ASP连接资料库问题
时间Thu Nov 22 17:40:48 2007
page=int(request.Querystring("page"))
If page<=0 then page=1
Set CN = Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath("../Publication/database/board.mdb")
CN.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath
Set RS = Server.CreateObject("ADODB.Recordset")
SortSql = "Select * From news order by number desc"
RS.CursorType=1
RS.LockType=1
RS.Open SortSql, CN
Count=RS.RecordCount
RS.PageSize=10 '每页几笔资料
TotalPage=RS.PageCount
if page>TotalPage then page=TotalPage
RS.MoveFirst
RS.Move (page-1) * 10 '移至第几页
Set rs1 = Server.CreateObject("ADODB.Recordset")
If int(Request.QueryString("ID")) > 0 then
SortSql1 = "Select * From news_detail where number ='"& Request.QueryString("ID")&"'"
else
SortSql1 = "Select * From news_detail where number = '001'"
End if
rs1.Open SortSql1, CN
Count1=rs1.RecordCount
-----------------------------------------------------------------
想请问一下RS可以抓到资料
为甚麽rs1都抓不到呢
count1 的值为 -1
资料库确定是有东西的
请问一下该如何修改呢
谢谢 ^^
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 140.112.251.222
1F：→ chaosrx:rs1.Open SortSql1, CN 後面要再加参数 61.67.135.17 11/23 13:01