Can't display result

[City Guy]

if (rs != null){
while(rs.next()){
state_name = rs.getString("state_name");
event_name = rs.getString("event_name");
event_desp = rs.getString("event_desp");
event_start = rs.getString("event_start");
state_plc = rs.getString("state_plc");
}
if (rs == null)
{
please try again
}
The reseult "please try again" cannot be display...
it only display a blank page..

[Dan Drillich]

Hi City Guy,
Are we speaking about Servlet code or JSP?
If it's a servlet, please replace -
please try againwith
out.println("please try again");
Cheers,
Dan

[Mike Curwen]

Watch your braces... you missed one... (the second if statement is always false)

if (rs != null){
    while(rs.next()){
state_name = rs.getString("state_name");
event_name = rs.getString("event_name");
event_desp = rs.getString("event_desp");
event_start = rs.getString("event_start");
        state_plc = rs.getString("state_plc");
  }
} // FORGOT THIS ONE...
  // without the above second brace, the next if statement will
  //*always* be false.. because we are here because rs != null
  // it should also be noted that this should be a simple 'else'
if (rs == null)   
{
   please try again
}

[Madhav Lakkapragada]

"City Guy"
your name doesn't agree with the javaranch guidelines.
please take a moment and re-register after reviewing the
guidelines at http://www.javaranch.com/name.jsp
please note fictious names donot qualify....
thanks for your cooperation.
- satya