How do I paginate the content in an ASP ACCESS field?

Pagination**:

set conn="")

set rs="")

sql="select * from student"

sql,conn,3

if request("page")<>"" thenepage=cint(request("page"))if epage<1 then epage=1if epage> then epage=elseepage=1

end if

rs(0).name%>

rs(1).name%>

rs(2).name%>

for i=0 to

if or then exit for%=rs(0).value%>

rs(1).value%>

rs(2).value%>

Home. > previous page.

Next page. Last.

Now it's page <%=epage%> there are <%=> pages.

The table has three fields, indicating that the others do not need to be changed, and the pagesize can also be changed, if there are fewer records.

If there is html**, it will be automatically interpreted as a web page, so don't worry.

To give you an idea:

Cut the size of the data object and insert a pagination mark in the appropriate place. When reading content, it is pagination at the position of the marker.

Hello landlord: You can take a screenshot of your text For example: there is string content = 5000 words You want to display 1000 words per page Then you can take a screenshot of the text on the home page, 1000) When you click on the next page, you should transfer the current page (currentpage) to the background For example, the home page is the first page Then in the background according to the 1 brought in method from the first page to get the second page to display the content and so on If you still have questions, you can contact me directly!

Here's how I did it, hoping to help you string content=(query content); string contentsub=number of pages * number of words displayed per page, number of pages * number of words displayed per page + number of words displayed per page);

Establish the access database news, as well as the table news, the field of the table (id, title), id unique, input data saving, with the following ** can be queried, can be pagination.

--Save below asID numberTitle

Amendments

Delete

target="_blank"><%=rs("title"Amendments

Delete%numrows=numrows+1

wend%>

Total <%=pagecount%> page <%=page%> page <%if page=1 then%> home<%end if%>1 then%>

Home. dim pagewhere

dim pp = 1

Convert pagewhere to an integer.

pagewhere = cint(request("pagewhere"))

pagewhere = pagecountif pagewhere>0 then

for p=1 to pagewhere

if p <>page then%>

cx=<%=cx%>"><%=p%>

end if%>

set rs=nothing

set conn=nothing

Click on the tab control, insert the tab, the tab is two pages by default! You can also insert pages and delete pages! It's best to look at it later on the form view!

I have a similar pagination program.,You can refer to it Create access database news,There is also a table news,The field of the table (id,title),id is unique,Enter data to save,Use the following ** can be queried,Can be pagination -- save as below。

ID number

Title

Amendments

Delete

target="_blank"><%=rs("title")%>

Modify>> Delete <% numrows=numrows+1 wend%>

Total <%=pagecount%> page<%=page%> Home<%end if%> if page>1 then%>"Home.

dim pagewhere dim p p = 1 'Convert pagewhere to an integer. 'pagewhere = cint(request("pagewhere")) pagewhere = pagecount if pagewhere>0 then for p=1 to pagewhere if p <>page then%> cx=<%=cx%>"><%=p%>

end if%>

set rs=nothing set conn=nothing %>

The correct way to write it is:

select top 10 * from table order by ..

That's not the case with pagination.

There are too many places to change, to give you an example, change it yourself, and leave one.

I don't know what exactly you're trying to ask in this question, is it pagination or what.