IS there a way for checking out the resultset for size.
I am doing something like this
select.from(TABLE_BOOKED_ROOMS).where("ROOM_room_id = " + room_id +
"");
String result = (String)manager.executeQuery(select, new
DbResultSetHandler() {
public Object concludeResults(DbResultSet resultset)
throws SQLException
{
resultset.next();
return resultset.getString("bookedroom_id");
}
});
However if booked_room table dosnt have any record for the given query
then it throws SQl exception java.sql.SQLException: Illegal operation
on empty result set.
Is there any way of checking out the size of resultset or may be other
way of doing it?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "rife-users" group.
To post to this group, send email to
rife-users@...
To unsubscribe from this group, send email to
rife-users+unsubscribe@...
For more options, visit this group at
http://groups.google.com/group/rife-users?hl=en-~----------~----~----~----~------~----~------~--~---