Example Code:
<%
sub= " order by c1"
SQL="select * from Table where c1='"&b1&"' " & sub
Set rs= GetSQLserverStaticRecordset( conn, SQL)
rs.AbsolutePosition=5
%>
<% =rs("c2") %>
----------------------------------------------------
<%
SQL="select * from aTable "
Set rs = GetSQLserverStaticRecordset( conn, SQL)
%>
<%
rs.PageSize = 10
rs.PageCount
ShowOnePage rs, Page
%>
<%
Sub ShowOnePage( rs, Page )
End Sub
%>
---------- tips memo ----------
For Access : GetMDBStaticRecordset ....
For Excel: GetExcelStaticRecordset
For FoxPro :GetExcelStaticRecordset
For Text : GetTextStaticRecordset
For dBase : GetdBaseStaticRecordset
For SQLserver : GetSQLserverStaticRecordset
儘量在有需要使用每筆資料的編號時
才使用static | 
