recordset >
getsqlserver-recordset

Get SQLserver Recordset - read data from SQLserver DB

由SQLserver 对象读取数据

Get SQLserver Recordset - read data from SQLserver DB

note: 
without using EOF or NOT EOF
will appear [ error '80020009' ]

<%
sub= " order by c1"	
SQL="select * from Table where c1='"&b1&"' " & sub
Set rs= GetSQLserverRecordset( conn, SQL)
' remark: it is not GetSQLserverStaticRecordset
' remark: so do not use rs.AbsolutePosition=n
%> 
<% =rs("c2") %>

---------example 2 ---------------
<%
If rs.EOF Then <---- in case nothing
else
rs.MoveFirst
  while Not rs.EOF
    response.write rs("cX")
  rs.MoveNext
Wend
End if
%>

display c2 data .....[ the first row list data ]

--------example 2 --------------
list all