Hi, I need help infomation from a record set into an 2D array.
Tried a few array tutorials but they just confuse me more lol. I need to put a number into the array every time there is a 'hit' with the name, but i cant get the array syntax quite right. Also how do i output this into a string ? (so i can do other things with it later on.)
Code:
<% set rs = conn.execute("SELECT * FROM table") %>
<%
Dim MyArray()
Redim MyArray(MaxRecords,1) 'Note i already have MaxRecords from previous code
i=0
While NOT rs.EOF
If rs.Fields.Item("Name") = "test" Then
'Need code to add 1 into an array for i.
Else
'Need code to add 0 into an array for i.
End IF
i=i+1
rs.MoveNext
Wend
%>Tried a few array tutorials but they just confuse me more lol. I need to put a number into the array every time there is a 'hit' with the name, but i cant get the array syntax quite right. Also how do i output this into a string ? (so i can do other things with it later on.)