Randomizing Database Questions

Expand Post »

Please.
I'm writing a Test Engine Software and I have a big issue. I have a large question database about 1000 questions and I need to load 50 random questions for each test instance. i.e Each time a user runs the test, 50 DISTINCT questions will be loaded.

They should not be the same every time and questions that have already been loaded and or answered should not be displayed again.

Right now, I have extracted all the questions into a ResultSet, is there a way I can shuffle the questions and select the top 50 into a new ResultSet and use the new ResultSet to administer the test. If it's possible, it'll make my job easier. If not, I'd really appreciate any help I can get.

Thanx

Luminus

Similar Threads

Creating MySQL database for a website in MySQL
Writing to an Access Database in Visual Basic 4 / 5 / 6
database questions I have in Database Design
database questions, software development in IT Professionals' Lounge
Beginner's questions: C++ and databases in C++

Luminus

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Nov 2004

Permalink

Dec 8th, 2004

Re: Randomizing Database Questions

no, that's not possible.
What I'd do is store the questions with a unique number as a key, then create 50 random numbers and pull the questions with those numbers out of the database.

jwenting

Team Colleague

Reputation Points: 1658

Solved Threads: 331

duckman

Offline

7,719 posts
since Nov 2004

Permalink

Dec 8th, 2004

Re: Randomizing Database Questions

Quote originally posted by jwenting ...

no, that's not possible.
What I'd do is store the questions with a unique number as a key, then create 50 random numbers and pull the questions with those numbers out of the database.

Could you please gimme some sample code so I know how to go about it and any other suggestions will be highly appreciated.

Thanx

Luminus

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Nov 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Java Forum Timeline: IE Browser shutting down and shows error on desktop

Next Thread in Java Forum Timeline: Creating Jars

DaniWeb Message

Cancel Changes

User Name
Password