How to get data from a particular row with microsoft jdbc for sql server 2000?

[NickName]

rs.getString(1) // return data for the first column in the resultset
rs.getString("LastName") // return data for the column named LastName
in the resultset

Now, if I want to return just row 5 of column "LastName", how do we go
about that?

rs.getString("LastName").getRow(4)?
// won't work, for one thing, getRow() method returns row number

thanks.

 

[Manish Pandit]

Now, if I want to return just row 5 of column "LastName", how do we go
about that?

You can use rs.relative(5) followed by rs.getString("LastName")

-cheers,
Manish