This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Hi, I have one jsp page containing 2o questions retrieved from table along with its possible four-option answer in this manner: Question1: Option-a Option-b Option-c Option-d All the options are in radio button form. I am trying to store the result of these question test in my final output table: Structure of this table is:
Eventide -> int(2)->data from another event table->getting value in update table Question id ->int(2) ->data from questionbank table-> getting value in update table
Serialno ->int(3) ->no. from questionbank table Answer -> varchar(2) -> value of the option selected from below question page> So structure of final table will be: Event-id question-id serial-no answer Same Same 1 a/b/c/d For all For all 2 a/b/c/d Question question 3 a/b/c/d
So, How it is possible to store the result of all question with answer equals to one of the four options in the same row of questioned. Is there required in looping in my insertdata.jsp page. Here questioned is same for all questions: Here is fillquestion.jsp page:
And here is an my insertdata.jsp page I am not sure about the code written in this page, kindly provide update