Current Recordset does not support bookmarks

Results 1 to 2 of 2

Thread: Current Recordset does not support bookmarks

  1. #1
    Join Date
    Dec 1969

    Default Current Recordset does not support bookmarks

    Hye all this peice of code had been working fine on my local servers but as soon as I tested it online I got this error message. Im presuming my ISP will not let me use the so called bookmarks, are my cursors ok for doing what I am doing here?<BR><BR>ADODB.Recordset error &#039;800a0cb3&#039; <BR><BR>Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype. <BR><BR>/d.asp, line 160 <BR><BR>160 is <BR>If intPageCount &#060;&#062; 0 Then objRS.AbsolutePage = 2<BR><BR><BR><BR>dim thisDate3, objRS<BR>dbOpen()<BR>Set objRS = Server.CreateObject("ADODB.Recordset")<BR>intPageS ize = 5<BR>objRS.PageSize = intPageSize<BR>objRS.CacheSize = intPageSize<BR>&#039;objRS.AbsolutePage = 2<BR>strSQL = "SELECT postdate, postid, heading FROM tblN ORDER BY PostDate DESC"<BR><BR>objRS.Open strSQL, dbConnect, 3, 3<BR>intPageCount = objRS.PageCount<BR><BR>If intPageCurrent &#062; intPageCount Then intPageCurrent = intPageCount<BR>If intPageCurrent &#060; 1 Then intPageCurrent = 1<BR>If intPageCount &#060;&#062; 0 Then objRS.AbsolutePage = 2<BR><BR>For i = 1 To objRS.PageSize <BR><BR>thisDate3 = objRS("PostDate")<BR>thisDate3 = Day(thisDate3) & "/" & Month(thisDate3) & "/" & Year(thisDate3)<BR><BR> If NOT objRS.EOF Then <BR> Response.Write "&#060;H4&#062;" & thisDate3 & "&#060;/H4&#062;"<BR> Response.Write "&#060;a class=mlinkru href=""news.asp?id=" & objRS("PostID") & """&#062;" & ucase(objRS("Heading")) & "&#060;/a&#062;" & vbCrLf<BR> objRS.Movenext<BR> end if<BR>Next <BR><BR>set objRS = nothing<BR>dbClose()<BR><BR>Help would be dandy.

  2. #2
    Join Date
    Dec 1969

    Default RE: Current Recordset does not support bookmarks

    Very inefficient!<BR><BR>If you have x records you are selecting the FULL x and only displaying 5.<BR><BR>This can cause problems!<BR><BR>I have a solution if you are using SQL Server<BR><BR>Give me your email!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts