Problems with recordset pagination in ASP

Specify the cursor parameter when rs is turned on.

sql,conn,1,1

Don't run it straight like this:

set rs =

To do this: set rs ="")

sql,conn,3,2

The root cause is the cursor.

<%dim pre,last,page,intpage,iset ors = "" )

ssql = "select * from newsdata order by d_id desc"

30 'This sets the number of records to be displayed per page.

3ssql,oconn,0,2,1 'Here you query the SQL and get the result record set.

pre = true

last = true

page = trim("page"))

if len(page) = 0 thenintpage = 1

pre = false

elseif cint(page) =< 1 thenintpage = 1

pre = false

elseif cint(page) >= thenintpage =

last = false

elseintpage = cint(page)

end if

end if

end if

if not then

intpage

end if

>"><%for i=1 to

if or then exit for%>

if ors("d_picture") <"" then%>">

end if%>

<%=outhtml(ors("d_title"))%else%>

<%=i%>

end if

next>page <%.

set ors= nothing

You can't seem to open like this with this pagination method, I've encountered it before.

You try rs, conn, 1, 3

or rs, conn, 0, 2, 1

It is recommended to read professional books on this subject, and it is difficult to get a satisfactory answer to this question.

The landlord is the same as I used to be.,Use table to operate horizontally.,Use div to operate horizontal.。

Direct Output: Your Content.

It's horizontal, and you don't have to worry about when to change the next line.

As for pagination, I used leaf pagination after countless tosses. It's the New Year, don't toss...