Results 1 to 3 of 3
  1. #1
    satish87 is offline Member
    Join Date
    May 2012
    Posts
    1
    Rep Power
    0

    Default Inserting form fields to database

    Hi All,
    I am stuck in a situation wherein i am given to design a form(financial year) which contains many unique fields.I want to know how do i insert these many fields to database as using prepared statement would mean my Insert statement would go endless(as the fields are 60).The form pattern is i have months vertically arranged and 5 headers (horizontally arranged).Also an option of using an array wont work since all the fields are unique..

    Any help would be highly appreciated.
    Thanks in advance

  2. #2
    doWhile is offline Moderator
    Join Date
    Jul 2010
    Location
    California
    Posts
    1,642
    Rep Power
    7

    Default Re: Inserting form fields to database

    Quote Originally Posted by satish87 View Post
    Hi All,
    I am stuck in a situation wherein i am given to design a form(financial year) which contains many unique fields.I want to know how do i insert these many fields to database as using prepared statement would mean my Insert statement would go endless(as the fields are 60).The form pattern is i have months vertically arranged and 5 headers (horizontally arranged).Also an option of using an array wont work since all the fields are unique..

    Any help would be highly appreciated.
    Thanks in advance
    I don't understand, are you saying that you have a table in your database with 60 columns? If so, might be time to rethink the design. If not, you might want to provide a bit more detail.

  3. #3
    Tolls is online now Moderator
    Join Date
    Apr 2009
    Posts
    12,009
    Rep Power
    20

    Default Re: Inserting form fields to database

    Presumably the form represents a financial year (you seem to have 12 months on it).
    So (in my mind) you have 12 rows to insert, one for each month, each containing 5 fields.
    Which is a going to be a batched PreparedStatement as, presumably, you do not want a partial commit.
    Please do not ask for code as refusal often offends.

    ** This space for rent **

Similar Threads

  1. Replies: 2
    Last Post: 05-16-2012, 09:54 AM
  2. Using Editable Pdf form fields in Application
    By jiten.mistry in forum Advanced Java
    Replies: 5
    Last Post: 09-21-2011, 08:37 PM
  3. Replies: 2
    Last Post: 07-01-2010, 02:32 AM
  4. Dynamic fields in form using Form Bean
    By janu.c in forum Java Software
    Replies: 1
    Last Post: 09-23-2009, 04:26 AM
  5. Inserting data to database from the form
    By Ms.Ranjan in forum JavaServer Pages (JSP) and JSTL
    Replies: 2
    Last Post: 06-17-2008, 01:06 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •