Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
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


JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQL Count" Watch "SQL Count" New topic
Author

SQL Count

Hus En
Greenhorn

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
Bartender

Joined: Nov 09, 2011
Posts: 1025
    
    5

I think you are calling the next() method too many times. Remove the call within your while loop.
 
GeeCON Prague 2014
 
subject: SQL Count