hi i'm having problems with my search logic if (rs!=null){ while(rs.next()) { } } else { out.println("no results") } it seem that if no results from databases it woudn't display "no results" can anyone pls help me.. thanx
if(rs!=null) { if(rs.next()) { //display result } else { //Not exist } } Hope this will work fine.. Pranit.
Originally posted by Jardel Tan: hi i'm having problems with my search logic if (rs!=null){ while(rs.next()) { } } else { out.println("no results") } it seem that if no results from databases it woudn't display "no results" can anyone pls help me.. thanx
I use this to find out if there's data back from database. This will show you how many rows are in the resultset. int rowcnt=0; rs.last(); rowcnt = rs.getRow();