Forums
This topic is locked
Paging a recordset and Form submission
Posted 01 Aug 2002 18:45:32
1
has voted
01 Aug 2002 18:45:32 Brad Matthews posted:
Hi,I am currently developing an online quiz that has all the questions and question options in a DB.
Each question has a totalScore and each option has a ratingScore.
I display 1 question per page.
All the options for that question are displayed via a filtered recordset that is nested on the page. This is fine and I can page through all the records in the DB without a problem.
The recordsets are enclosed inside a form which will pass the questionID, the optionID and the ratingScore, store them in a string array and score them at the end of the quiz.
My methodology is that after answering the question they submit the form appending the new values.
The problem I am facing is that I can either page through the recordset or submit a form but not both.
Can a form button also page through the recordset? What would the form action be? Should I use a post or get method? Am I approaching this incorrectly?
Any explanations or advice as to a methodology or process to assist in getting my head around it will be much appreciated.
Thank you
-brad-