Array help

[TGP Thought Meister]

Need some help with an array problem.

I am pulling several rows from my database and placing them into an array
successfully but I want to be able to pull them randomly. I can't decide the
best way to proceed, whether to create another array with the DB ID's and
then run a check each time I generate a random number against this array? Or
should I delete the record from the array each time through with the random
number?

Any ideas?

[Ray at]

You can retrieve the records in random order when you get the recordset.
See here.

http://rtfm.atrax.co.uk/infinitemonk...es/sql/994.asp

Ray at work

"TGP Thought Meister" <tg*@nowhere.com> wrote in message
news:e9**************@TK2MSFTNGP10.phx.gbl...

Need some help with an array problem.

I am pulling several rows from my database and placing them into an array
successfully but I want to be able to pull them randomly. I can't decide the best way to proceed, whether to create another array with the DB ID's and
then run a check each time I generate a random number against this array? Or should I delete the record from the array each time through with the random number?

Any ideas?

[Dave Anderson]

"TGP Thought Meister" wrote:

I am pulling several rows from my database and placing them into
an array successfully but I want to be able to pull them randomly...

Depending on your database, you could simply return the records in random
order. In SQL Server, for example, you could use the following:

SELECT ... ORDER BY NEWID()
--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

[TGP Thought Meister]

Perfect, thanks.
"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:ut**************@TK2MSFTNGP12.phx.gbl...

You can retrieve the records in random order when you get the recordset.
See here.

http://rtfm.atrax.co.uk/infinitemonk...es/sql/994.asp

Ray at work

"TGP Thought Meister" <tg*@nowhere.com> wrote in message
news:e9**************@TK2MSFTNGP10.phx.gbl...

Need some help with an array problem.

I am pulling several rows from my database and placing them into an array successfully but I want to be able to pull them randomly. I can't decide the

best way to proceed, whether to create another array with the DB ID's and then run a check each time I generate a random number against this

array? Or

should I delete the record from the array each time through with the

random

number?

Any ideas?