Hi ,
Thanks in advance for help
Specific requirement:
I have to create dynamic text input fields based on a number input which shall divide a given range
eg. Start date,end date will be provided and a number to divide this date range will be provided (all these 3 parameters could change later)
Based on current values (eg, start date of 1st Jan 2011 and end date of 31st December 2011 and monthly interval ),I will have 12 text input fields
in this case it will be entry for Jan,feb March,.....December
Now above values could change eg. start date of 1st Jan 2011 and end date of 31st May 2011( 6 months) and weekly interval , so I will have 6*4=24 columns 1st Jan to 7th Jan,7th Jan to 15th Jan ,15th to 22nd and 22nd to 31st and so on
While I can think of creating dynamic columns in terms of html,I was wondering how should I design my database to save these values
I mean the column count will keep changing based on input by user
In which direction I should think..Database or Java code
Thanks
Ketan