• Post Reply 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Devaka Cooray
  • Knute Snortum
  • Paul Clapham
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Bear Bibeault
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Ron McLeod
  • Piet Souris
  • Frits Walraven
Bartenders:
  • Ganesh Patekar
  • Tim Holloway
  • salvin francis

data in table getting overridden?  RSS feed

 
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a calendar program in jsp. The page submits to itself. Am performing 2 insertions in it,
(i) when the user selects a date, they can enter some description of the date and store it in database.
(ii) when the calendar page gets loaded, depending on the user selected year,all the saturdays and sundays of the year, get inserted into database.

The second insertion am able to do, but am having trouble with the first insertion. when i try to insert the data, its not getting inserted. And also,if the users select 2006 then saturdays and sundays of 2006 get in, next time when user selects 2007, only the saturdays and sundays of 2007 are only available in database..
I have used MYSQL as database. Holiday is the table name. Fields are HolidayDate which is primary key and is a date field
Description is varchar field
Weekender is char field
Program name : CalendarPage.jsp

This is the part of code, which is making the insertion of the first part.

Am able to print the list values, but those dates are not getting into database.Is there anything wrong in the query?
Please help??
[ March 30, 2006: Message edited by: Bear Bibeault ]
 
Sheriff
Posts: 67257
170
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moved to the JDBC forum.
 
I knew I would regret that burrito. But this tiny ad has never caused regrets:
ScroogeXHTML - small and flexible RTF to HTML converter library
https://coderanch.com/t/710903/ScroogeXHTML-RTF-HTML-XHTML-converter
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!