Building array with GetString result

[jwoughter]

I have a query that, at this moment, only returns 2 records. Also, I'm only returning 1 column from the records as that is all I need.

I use rs.GetString to return the results in a nice list.

I want to pull, out of that list, 1 item at a time.

Ultimately, I want to be able to get a list of records that meet the query requirements, put them in an array, and randomly select one of the records to display on the web.

Does anyone know a way I could accomplish this?

 

[mharroff]

why not use myArray = rs.GetRows()

 

[jwoughter]

because i didn't know about that. lol

using that method, would i be able to do a myarray(0) or myarray(1) to get the record i want out of the list?

 

[vicvirk]

It actually adds it into a 2-dimensional array

Read about it here

http://www.w3schools.com/ado/met_rs_getrows.asp

if you want a single dimensional array, you can do something like this:

dim myArray()
set myRS = myConn.execute(mySQL)
	myRS.movefirst
	i = 1
	do while not myRS.eof
		redim preserve myArray(i)
		myArray(i) = rs("myField")
		i = i + 1
		if not myRS.eof then myRS.movenext
	loop
	myRS.close
set myRS = nothing

--------
GOOGLE is a great resource to find answers to questions like "how do i..."

If you don't know exaclty what you want to do or what to search on, try Google Suggest:

http://www.google.com/webhp?complete=1&hl=en

--------
I have recently been semi-converted to ensuring all my code (well most of it) works in both javascript and non-javasc