Win a copy of Node.js Design Patterns: Design and implement production-grade Node.js applications using proven patterns and techniques this week in the Server-Side JavaScript and NodeJS forum!
    Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

How to store option format value in database in jsp

 
Ranch Hand
Posts: 151
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
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


Thanks and Regards
Harshal

Thanks in advance
 
Bartender
Posts: 2856
10
Firefox Browser Fedora Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Report post to moderator
Please do not post the same question multiple times.
 
Doody calls. I would really rather that it didn't. Comfort me wise and sterile tiny ad:
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
    Bookmark Topic Watch Topic
  • New Topic