<%
PN=CLng (ABS (Request (" PN ")))
If Not IsNumeric (PN) Or PN & lt;=0 Then the PN=1
IntPageSize=DataPageSize
Pagenum=intPageSize * (PN)
Set the rs=Server. CreateObject (" ADODB. You ")

IF the PN=1 THEN
rs. Open the "Select top" & amp; IntPageSize&" * From [Records] where cID<> "'" & amp; Sql&" The Order By rids Desc ", conn, 1, 1
The ELSE
Rs. Open the "Select top" & amp; IntPageSize&" * From [Records] where cID<> "'" & amp; Sql&" And rids & lt; (SELECT Min (rId) FROM (SELECT TOP & amp; "" Pagenum&" RId the FROM [Records] where cID<> "'" & amp; Sql&" The ORDER BY rids AS T) ORDER BY desc) rids desc ", conn, 1, 1
END the IF
The Set Rsstr=conn. Execute (" Select count (rId) As RecordSum From [Records] where cID<> "'" & amp; Sql&" ", 1, 1)

CodePudding user response:

Thank you great god help, online, etc.,

CodePudding user response:

Pray god to help small white thanks

CodePudding user response:

yuiukl8l78l9l9l89l8

CodePudding user response:

The output of the SQL you see,

CodePudding user response:

This fault should be in your SQL data types in can check

CodePudding user response:

Response. Write "Select top & amp;" IntPageSize & amp; "* From [Records] where cID<> "'" & amp; SQL & amp; "Order By rids Desc" output to see what will know where is wrong

CodePudding user response:

The not cID is null