asp ima chudesni vgradeni funkcii za rabota s recordseti, vupreki che samia sql ne poddurja onova, koeto ima mysql - komandata limit. tuk ima samo TOP xxx.

eto i moeto predlojenie

<%

if isnumeric(request.querystring("page")) and request.querystring("page")<>"" then _
page=cdbl(request.querystring("page") else page=1
' tva ti e stranicata, predava se kato ?page=4 primerno


sql="select ..."
set rs=server.createobject("ADODB.Recordset")

rs.open sql, connection, 3
rs.pagesize=20 'primerno
if rs.eof then
'niama rezultati
else

if page<rs.pagecount then
rs.absolutepage=page
else
rs.absolutepage=rs.pagecount 'ili na 1
end if

end if

i=0
do while not rs.eof and i<rs.pagesize
..............looping trough code............
rs.movenext
i=i+1
loop

'stranichki
for i=1 to rs.pagecount
%><a href=?page=<%=i%>><%=i%></a> <%
next

%>

Good LUCK! :)

Редактирано от dzver на 21.04.02 23:07.