User Profile

Collapse

Profile Sidebar

Collapse
camarun20
camarun20
Last Activity: May 9 '08, 06:20 AM
Joined: Apr 1 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • camarun20
    replied to How to fetch records randomly every time you query
    in Access
    Hi Stewart ,

    Thanks for finding your time in replying me. I understood your point well.

    Let me explain you my requirement in brief.

    I am in a process of creating a online test portal.
    There is a table called "Questions" which has 4000 rows in it. When a user takes test , some 30 questions has to be picked up randomly and displayed to the user.

    When a second user takes...
    See more | Go to post

      Leave a comment:

    • camarun20
      started a topic How to fetch records randomly every time you query
      in Access

      How to fetch records randomly every time you query

      Hi ,
      I constructed an MS access query in java to retrieve the rows in random.

      The code snipet

      Connection con = DriverManager.g etConnection( database ,"","");
      Statement s = con.createState ment()
      strQry = "select top 10 S_No , Rnd(S_No) as exp from Questions order by Rnd(S_No) desc" ;
      s.execute(strQr y) ;


      This is the query I used...
      See more | Go to post
      No activity results to display
      Show More
      Working...