作者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