<%
PN = CLng(ABS(Request("PN")))
If Not IsNumeric(PN) Or PN <= 0 Then PN = 1
intPageSize = DataPageSize
pagenum = intPageSize*(PN-1)
Set rs = Server.CreateObject("ADODB.Recordset")
IF PN=1 THEN
rs.Open "Select top "&intPageSize&" * From [Records] where cID<>'' "&sql&" Order By rId Desc",conn,1,1
ELSE
rs.Open "Select top "&intPageSize&" * From [Records] where cID<>'' "&sql&" and rId < ( SELECT Min(rId) FROM ( SELECT TOP "&pagenum&" rId FROM [Records] where cID<>'' "&sql&" ORDER BY rId desc ) AS T ) Order By rId Desc ",conn,1,1
END IF
Set Rsstr=conn.Execute("Select count(rId) As RecordSum From [Records] where cID<>'' "&sql&" ",1,1)
uj5u.com熱心網友回復：
大神幫忙 ,在線等 ,感謝uj5u.com熱心網友回復：
求大神幫幫忙 小白謝謝了uj5u.com熱心網友回復：
yuiukl8l78l9l9l89l8uj5u.com熱心網友回復：
輸出你的 sql看下。uj5u.com熱心網友回復：
這個錯應該是你SQL中的資料型別對不上 可以查一下uj5u.com熱心網友回復：
Response.Write "Select top " & intPageSize & " * From [Records] where cID<>'' " & sql & " Order By rId Desc" 輸出看下是什么就知道錯在哪里了uj5u.com熱心網友回復：
not cID is null轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/45504.html
標籤：ASP