ResultSet return value for an empty query

[david allen]

When a query is executed and no resutls are found what value is returned to the ResultSet. In other words I need to determine if the ResultSet is empty.
What method do I use
thanks david

[Avi Abrami]

Hi David,
After you have obtained a "ResultSet", for example:

Connection dbConn = ...
String qry = "SELECT ..."
Statement stmt = dbConn.createStatement();
ResultSet rs = stmt.executeQuery(qry);

then if that "ResultSet" is 'empty', the first invocation of the "ResultSet" methos "next()" will return 'false', as in:

rs.next();  // returns 'false' if no "next" row.

Hope this answers your question.
Good Luck,
Avi.