rs=stm.executeQuery("select news.news_id,to_char(news_date,'dd-MON-yy HH:MM:SS AM'),heading,desc1,desc2 from news where sysdate<=news_date + interval '2' day order by news_date desc");
while(rs.next()){
newsDate=rs.getString("news_date");
out.println("News ID"+rs.getString("news_id")+"<div align=right>"+newsDate+"</div><br>");
news_id=rs.getInt("news_id");
heading=rs.getString("heading");
out.println("<tr><td><a href=http://localhost:5050/examples/servlet/displayNews?newsID="+news_id+"><font color=olive face='times new roman' size=3><b>"+heading+"</a></font></td></tr>");
out.println("<tr><td>"+rs.getString("desc1")+"<a href=http://localhost:5050/examples/servlet/displayNews?newsID="+news_id+"> Details.....</a><br><br></td></tr>");
}
news_date exists in DB but it gives
Error:
Invalid column name