Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Problem in getting data from MSAccess  RSS feed

 
Srinivasa Raghavan
Ranch Hand
Posts: 1228
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a column in a MSAccess table. That column had alphanumeric data.
For example : it can have datas like: abc, some value, 1,2,3, xyz

The problem here is when I use rs.getString("columnName") , for all String values, I get the exact data from DB but if the value is 1 or 2, i'm getting an empty string.
Can anyone guide me.
 
Shankar Narayana
Ranch Hand
Posts: 134
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

What is the datatype for that column in the database, basically it shoudn't be a problem, try to refer to the column value where you are getting empty string, might be that column hasn't got any data in it.


Regards
Shankar.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!