wood burning stoves*
The moose likes JDBC and the fly likes SQL Count Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQL Count" Watch "SQL Count" New topic

SQL Count

Hus En

Joined: Feb 28, 2013
Posts: 4
Hi, sorry for my bad english... anyone please help me, im struggling to get resultset from a SQL count statement..
i have 2 pages.. attendance.jsp page which takes all the necessary information entered by user and send it to the setAtnd.jsp page via ajax.. to calculate attendance i need to do a calculation which is depending on the query which executes on setAtnd page.. but im having problem in geting the correct value from the query please help..
please help me asap.. thank you
here is my code..

1) Attendance.jsp

2) setAtnd.jsp

[Screen Shot 2013-03-17 at 12.35.16 PM.png]

James Boswell

Joined: Nov 09, 2011
Posts: 1012

I think you are calling the next() method too many times. Remove the call within your while loop.
It is sorta covered in the JavaRanch Style Guide.
subject: SQL Count
Similar Threads
please....help me in jsp checkbox display code
Problem executing SQL in SERVLET.
How to get ajax response in jsp page
Ajax in JSP
Ajax in JSp