Populate array from database
Posted on 2003-12-11
Heres what I have so far. In my database there is a table that holds all the news items and the date for each. I am using the following code to retrieve the top 6 items.
lsSQL = "SELECT TOP 6" & _
"NCount, NewsDate, SuperScript, NYear, NewsData " & _
"FROM " & _
"dbo.tblNews" & _
"ORDER BY " & _
Set loCommand = Server.CreateObject("ADODB.Command")
Set loCommand.ActiveConnection = poConnection
loCommand.CommandType = adCmdText
loCommand.CommandText = lsSQL
Set GetUserData = loCommand.Execute
Set loCommand = Nothing
What I would like to know is how can I take the data from this and place it into an array that will hold all 6 rows of data. I want to take this array and then be able to populate the news page with these 6 items. So I would need an array that will hold...
6 times over. Is this possible or just to much work? I have never worked with arrays before and am at a total loss here. I have no idea how to fill the array and then once it is filled how to use it to create the news on the page.