• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

values from users show null when entered into database

 
Yahya Arshad
Greenhorn
Posts: 26
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi i am using mySQL with jsf i have a problem when i hit submit button after filling out form the database fill with null values instead of values that i enter in form...

here is my managedBean



here is my Sql Query

i have also tried using this.dob , this.getDob() , dob, but the value goes in database is always null...

here is my full action which invoked on press of submit button



if i put values in query my self instead of taking from user it works fine..

please help me
 
Bobby Smallman
Ranch Hand
Posts: 107
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have you double checked that the Dob string is actually set when you are forming the query string? Perhaps you are having a problem prior to the query since you have tested the same query with manually entered data.
 
Cristian Adinanda
Greenhorn
Posts: 9
Eclipse IDE Firefox Browser Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Bobby Smallman wrote:Have you double checked that the Dob string is actually set when you are forming the query string? Perhaps you are having a problem prior to the query since you have tested the same query with manually entered data.



i agree, please debug it first for the this.getDob() to make sure it parse String that have non-value .
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic