• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem in getting data from MSAccess

 
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic