display no results

[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

[David O'Meara]

The first result is always empty, so the coe you are looking for is:

if(rs.next())
{
    performAction();
    while(rs.next())
    {
        performAction();
    }
}
else
{
    nothingReturned();
}

You could get more specific information in the JDBC forum.
Dave.

[Pranit Saha]

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

[Tim Holloway]

As you can see, there's more than one way to do it. I like this one:

   boolean haveData = false;
   while ( rs.next() ) {
       haveData = true;
       doSomething();
   }
   if ( ! haveData ) {
       out.println("<h2>Sorry, no data was found</h2>");
   }

[java alltheway]

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();

[Jardel Tan]

yeah! u guys r great!
thanx