Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

error in comparing data in database with user entered data

 
hemapriya rao
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am trying to compare data in database with user entered data,
even though both the values are same its showing me they are not equal..
and I also noticed one more thing ,my strings length in database is 2 more that the original length, [ database value= panda then length should be 5 , but its showing me as 7]



Please could some one help me out..
[ October 03, 2007: Message edited by: hemapriya rao ]
 
Tarun Yadav
Ranch Hand
Posts: 134
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have you checked to make sure there isn't any whitespace in the value stored in the DB? Try using a trim() while comparing.
 
hemapriya rao
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks Tarun its working now
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic