plz help me

[nobr]PreparedStatement ps=cnn.prepareStatement(query);

ps.setString(1, coemail);

rs=ps.executeQuery();

if(rs.next()){

r_id=rs.getInt(1);

co_id=rs.getInt(2);

if(!coemail.equals(rs.getString(3))){

out.println("<br><br><br><center><font color=red size=3><b>Access Denied</b></font>");

}

elseif(!remail.equals(rs.getString(4))){

out.println("<br><br><br><center><font color=red size=3><b>Registrant Email is incorrect</b></font>");

}

elseif(!rdob.equals(rs.getString(5))){

out.println("<br><br><br><center><font color=red size=3><b>Date of Birth is incorrect</b></font>");

}

else{

res.sendRedirect("/servlet/forgetPass1?co_id="+co_id);

}

}

ps.close();

the first if statement is not working. please help me i.e.

if(!coemail.equals(rs.getString(3))){

out.println("<br><br><br><center><font color=red size=3><b>Access Denied</b></font>");

}

thanks & kind regards[/nobr]

[1913 byte] By [farakha] at [2007-11-27 4:59:41]
# 1
Please ignore this post. Problem solved
farakha at 2007-7-12 10:16:02 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2
After all, the <center> and <font> tags are deprecated for years and the use of it is discouraged. Rather use CSS.
BalusCa at 2007-7-12 10:16:02 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 3
thanks BaluC for guidence.
farakha at 2007-7-12 10:16:02 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...