Is that possible? give me idea, How?

Hi all,

I am implementing online examination using Struts. ....

Is that possible that different-different candidates get same questions but in different order.

what i am trying to say is , I fetched the list of questions from DB and iterate it in the JSP but what i want is different candidates get it in a random order. means questions should b same but not in same order for each candidate.

Is that possible if yes then how give me some idea..

thanx

[488 byte] By [java_usera] at [2007-10-3 9:17:50]
# 1
if u are using Mysql you just write the query like this it will create random list.."select * from question_info rand()"it will do that..
Daiesha at 2007-7-15 4:30:48 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 2

thanx for replying.....

but that would not work bcause I hit the DB only one time na for every candidates. My list is one(common) which display the Questions on the candidate screen.

even if it picks question randomly but at front-end it display all the quest in a same order to all the candidates.

java_usera at 2007-7-15 4:30:48 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 3
which database you are used?
Daiesha at 2007-7-15 4:30:48 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 4
oracle......thanx for replying,I think it would work ... I got a query toothanx
java_usera at 2007-7-15 4:30:48 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...
# 5
SELECT * FROM ques_info ORDER BY dbms_random.randomi thing it will work..
Daiesha at 2007-7-15 4:30:48 > top of Java-index,Enterprise & Remote Computing,Web Tier APIs...