---
title: "rs.absolutepage, rs.pagecount -1"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/60085-rs-absolutepage-rs-pagecount-1"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "LR^evil.sid"
published: "2002-11-24T15:42:10.000Z"
updated: "2002-11-24T16:06:17.000Z"
replies: 3
views: 272
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/asp/60085-rs-absolutepage-rs-pagecount-1"
---

# rs.absolutepage, rs.pagecount -1

## #1 — LR^evil.sid, 2002-11-24T15:42Z

hur kan det komma sig att rs.absolutepage och rs.pagecount har värdet -1

```
<!-- #include file = 'inc/head.asp' -->
		<table>
<%
	dir = request.querystring("dir")
	sql = "select * from copforum order by postdate desc"
	openPg(sql)
	rs.pageSize = 10

	select case dir
		case "prev"
			if pgNo > 1 then pgNo = pgNo - 1 else pgNo = 1
		case "next"
			if rs.absolutePage < rs.pageCount then pgNo = pgNo + 1 else pgNo = rs.pageCount
		case "choice"
			if rs.absolutePage < pgNo then pgNo = request.querysting("choice") + 1
			if rs.absolutePage > pgNo then pgNo = request.querysting("choice") - 1
		case else
			pgNo = 1
	end select

	response.write _
		"<table>" & _
		"<tr><td>rs.absolutePage</td><td>: " & rs.absolutePage & "</td><tr>" & _
		"<tr><td>rs.pageCount</td><td>: " & rs.pageCount & "</td><tr>" & _
		"<tr><td>pgNo</td><td>: " & pgNo & "</td><tr>" & _
		"</table>"

	if not rs.eof then
[b][line 30]	rs.absolutePage = int(pgNo)[/b]

		response.write _
			"<tr><td><a href = 'administration.asp' title = 'Tillbaka till administrationen'>Administrationen</a> -> polisforum</td></tr>"

		for x = 1 to rs.pagesize
			if rs.eof then
				response.write sql
				exit for
			else
				response.write _
					"<tr><td><a href = 'view.asp?topicid=" & rs("id") & "' title = '" & rs("post") & "'>" & rs("topic") & "</a></td></tr>"
			end if
			rs.movenext
		next

		if rs.pageCount > 1 then
				response.write _
					"<tr><td><a href = '?dir=prev'>prev</a></td>"
				for x = 1 to rs.pageCount
					response.write _
						"<td><a href = '?dir=choise&pgNo=" & x & "'>" & x & "</a></td>"
				next
				response.write _
					"<td><a href = '?dir=next'>next</a></td></tr>"
		end if
	end if
%>
		</table>
<!-- #include file = 'inc/foot.asp' -->
<%
	sub openPg(sql)
		set con = server.createobject("adodb.connection")
		set rs  = server.createobject("adodb.recordset")
		con.open "driver={mysql};option=16386;server=localhost;database=database;uid=uid;pwd=pwd"
		rs.open  sql, con, 3, 3
	end sub
%>
```

felmeddelande:

```
ADODB.Recordset error '800a0cb3' 
Object or provider is not capable of performing requested operation. 
/ampyforum/administration.asp, line 30
```

Värt att nämna kan vara att det finns 13 poster i databasen för tillfället.

Permalänk: https://www.webforum.nu/p/60085

## #2 — OveRRidE, 2002-11-24T16:00Z

Använder du execute?

Permalänk: https://www.webforum.nu/p/863374

## #3 — LR^evil.sid, 2002-11-24T16:04Z

nej

```
<%
	sub openPg(sql)
		set con = server.createobject("adodb.connection")
		set rs  = server.createobject("adodb.recordset")
		con.open " driver={mysql};option=16386;server=localhost;database=databa
se;uid=uid;pwd=pwd"
		[b]rs.open  sql, con, 3, 3[/b]
	end sub
%>
```

Permalänk: https://www.webforum.nu/p/863375

## #4 — Eitraz, 2002-11-24T16:06Z

Av min erfaranhet så är recordcount och absolutepage inge vidare o använda när man har MySQL ;)

\-Eitraz

Permalänk: https://www.webforum.nu/p/863378

---

Tråden på webben: https://www.webforum.nu/amne/asp/60085-rs-absolutepage-rs-pagecount-1