Peter J. Boettcher — Thu, 24 Jan 2002 17:28:11 +0000

I was going to suggest using two arrays. Good idea!

Detox, thanks for going the extra mile, great work!

artsapimp — Thu, 24 Jan 2002 15:04:01 +0000

Thank you very much for the responses. I have also been working on another way of making this happen because I was not good enough at coding to do what you were able to do detox. My way is working, let me explain what I did.

I have an array being built from the DB using GetRows. Once the data is dumped to the array I run a random script which will select one record from the array. That number is then saved to a new array and then moved to the last record in the array...

Sub RemoveQuestion(intRecID)
QuestionArray(1,intRecID) = QuestionArray(UBound(QuestionArray,2))
Redim Preserve QuestionArray(UBound(QuestionArray,2) - 1)
End Sub

'
I then have the same array with 1 less record which is the one I just chose. While looping through that it removes each record requested.

The reason I sent it to another array is so I can pass that through the querystring or anywhere to reference the order later.

Does this make sense to do it this way? Any suggestions?

detox — Thu, 24 Jan 2002 14:38:05 +0000

OK,

here we go. My hosts server was down for a bit. You can download it all here http://detoxdezigns.com/TWF/quiz.zip

The db and asp page are all there in a zip file. The code is commented quite heavily but if you have any problems give me a pm and well work through them. The way the questions and answers are displayed can be changed really easily.

Mark Hensler — Thu, 24 Jan 2002 06:20:34 +0000

wow... quick

If you want random numbers that don't repeat, use a loop and an array. In the loop, grab a random number and check to see if it's in the array. If so, loop and try again. Once you've got a number that is not in the array, exit the loop. Add the number to the array, and use it where ever you needed it for (DB query, etc.).

Did that make any sense?

detox — Thu, 24 Jan 2002 05:51:40 +0000

I have it done.

I have a db with 40 questions in it, and the corresponding answers. I have built a quiz with 10 questions, and put it in the form of a multiple choice quiz, if you want to change it you can. I'll zip it up (db and all) and put it on my site for you...

will get back to you with a link soon.

detox — Thu, 24 Jan 2002 02:12:18 +0000

simply tag the questions that you get from the random function so that if the question is picked again it will be disregarded.

I'll have a go at something for you.....