ResultSet Error

Hello all,

I am checking if a particular value exist in my first column.When obtained i want to display it ,but using result set getString() method i get error of cursor position..since my table value are unique my result set will always have 1 row .....so how to fetch this string in first coumn..

.....this is what i have done

//sql contains my search string

rs=stmt.executeQuery(sql);

if(rs.wasNull())

{

System.out.println("not found");

}

else

{

System.out.println("found: "+rs.getString("Value");

}

[857 byte] By [codeit@717a] at [2007-11-26 16:11:18]