Resultset error
hello
i need to sum all the values in the column called price which is in DataBase, but when i use :
<% Statement s = con.createStatement();
ResultSet rs = s.executeQuery("select SUM(after_discount) from details"); %>
<%= rs %>
i am getting msg as "sun.jdbc.odbc.JdbcOdbcResultSet@1d95da8" .... i dont know why....
as s.executeQuery() returns ResultSet... so i am using ResultSet rs....
can you plz tell me is any other way to get the output which sums the column???;)
|