Använder du execute?
Frågan#1
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.

