nextRecorset

Hello
You only need to close de RS, when the you finish all your query, for
example:
<%
Dim strCnn
strCnn = "Provider=SQLOLEDB; Data Source$.232.0.50,1433; Initial
Catalog=theedgesport;User ID=theedgesport ;Password¥hyt79;"
Set Conexion = CreateObject("ADODB.Connection")
conexion.Open strCnn
Set rs = Server.CreateObject("ADODB.Recordset")

' CODE HERE, PAGING, ETC, ETC

Conexion.Close
Set Conexion = Nothing
%>

FF
www.francofigun.com.ar
www.microsofties.com.ar
MSN:
UIN: 314408886
Yahoo MSN:
"Hernán Castelo" escribió en el mensaje
news:

hi,
if i gather several recordsets from a stored procedure...

does it is sufficient to close the last RSet
of a RSet collection?
or do i need to close each RSet ?

thanks

atte,
Hernán Castelo
SGA - UTN - FRBA