| Author |
Problem in getting data from MSAccess
|
Srinivasa Raghavan
Ranch Hand
Joined: Sep 28, 2004
Posts: 1228
|
|
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.
|
Thanks & regards, Srini
MCP, SCJP-1.4, NCFM (Financial Markets), Oracle 9i - SQL ( 1Z0-007 ), ITIL Certified
|
 |
Shankar Narayana
Ranch Hand
Joined: Jan 08, 2003
Posts: 134
|
|
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.
|
"Failure is not when you fall down; its only when you fail to get up again."
|
|
 |
|
|
subject: Problem in getting data from MSAccess
|
|
|
0
