This week's book giveaway is in the Jython/Python forum.
We're giving away four copies of Murach's Python Programming and have Michael Urban and Joel Murach on-line!
See this thread for details.
Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

error in comparing data in database with user entered data  RSS feed

 
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
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!