[問題] ASP連接資料庫問題

[Phizek ()]

   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
→ chaosrx:rs1.Open SortSql1, CN 後面要再加參數