<div>
I have two tables here--the first being the typical way that you would iterate through the recordset, the second &nbsp;using the GetRows() method.<br />
<br />
FtB
</div>


I have two tables here--the first being the typical way that you would iterate through the recordset, the second  using the GetRows() method.

FtB

<div>
Thanks FtB, <br />
<br />
this was the first time i was trying the getrows method and i ran into problems. I will test this code in a few min and close this question. <br />
<br />
Thank you,<br />
:) SD
</div>


Thanks FtB,

this was the first time i was trying the getrows method and i ran into problems. I will test this code in a few min and close this question.

Thank you,
:) SD

<div>
Thanks FtB, it works like a charm<br />
<br />
:) SD
</div>


<div>
Glad to have helped,<br />
<br />
FtB
</div>


<div>
<div class="content wysiwyg-content">
Objective: to get the recordset into an array<br />
<br />
Got a wierd problem with using GetRows. <br />
<br />
&lt;%<br />
' Connection Strings have been set<br />
<br />
set rs = Server.CreateObject(&quot;ADODB<wbr />.recordset<wbr />&quot;)<br />
SQL = &quot;SELECT TeamName FROM teams&quot;<br />
rs.Open SQL, conn <br />
<br />
dim arrTeams<br />
arrTeams = rs.GetRows()<br />
<br />
response.write Ubound(arrTeams) &amp;&nbsp;&quot;&lt;br&gt;&quot;<br />
%&gt;<br />
returns:<br />
0<br />
<br />
&lt;%<br />
for each z in arrTeams<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;response.write z &amp;&nbsp;&quot;&lt;br&gt;&quot;<br />
next<br />
%&gt;<br />
returns the following:<br />
Rockets<br />
Knicks<br />
Lakers<br />
Jazz<br />
Hawks<br />
Clippers<br />
<br />
<br />
How can i get the recordset into an array so that I can reference it as arrTeams(0) ... arrTeams(Ubound(arrTeams))<wbr /><br />
<br />
:) SD
</div>
</div>


Objective: to get the recordset into an array

Got a wierd problem with using GetRows. 

<%
' Connection Strings have been set

set rs = Server.CreateObject("ADODB.recordset")
SQL = "SELECT TeamName FROM teams"
rs.Open SQL, conn 

dim arrTeams
arrTeams = rs.GetRows()

response.write Ubound(arrTeams) & "<br>"
%>
returns:
0

<%
for each z in arrTeams
	response.write z & "<br>"
next
%>
returns the following:
Rockets
Knicks
Lakers
Jazz
Hawks
Clippers


How can i get the recordset into an array so that I can reference it as arrTeams(0) ... arrTeams(Ubound(arrTeams))

:) SD

Problem: Using GetRows()

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.