recordset >
getsqlserver-staticrecordset

Get SQLserver Static Recordset - read data from SQLserver DB

由SQLserver 对象读取数据,
计录出笔数并将每笔资料编号

GetSQLserverStaticRecordset [ includes static counting ]

GetSQLserverRecordset [ no static counting ]

含有static时将使用主机较多资源

<%
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

display number 10's c2 data

------------------------------------------

list 10 raw a page

create a number (rs.PageCount) for each raw