This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
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 OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
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: 1012
    
    5

I think you are calling the next() method too many times. Remove the call within your while loop.
 
Consider Paul's rocket mass heater.
 
subject: SQL Count