aspose file tools*
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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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: 973

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
Similar Threads
Ajax in JSP
Ajax in JSp
Problem executing SQL in SERVLET. me in jsp checkbox display code
How to get ajax response in jsp page