File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 1051

I think you are calling the next() method too many times. Remove the call within your while loop.
I agree. Here's the link:
subject: SQL Count
It's not a secret anymore!