Forums Register Login

getting resultset without record in table

+Pie Number of slices to send: Send
Hi friends
i have written this code of block in work.jsp to check if record exist in DB

function called by myCon



all is well only problem is that even when there is no record in DB, this code is getting resultset object.
Table is completely blank.
I just copied the query and run it from cmd it returned emptyset.
+Pie Number of slices to send: Send
I got the loophole.
As i was not using result.next() to check if it is empty.
resolved now.
+Pie Number of slices to send: Send
Are you sure that belongs in a JSP file? Looks very much like Java code to me.
+Pie Number of slices to send: Send
This is the code in a class used inside jsp
+Pie Number of slices to send: Send
So the bit of code with the try block in it is in a .java file?

If so then that's ok. If it's in a .jsp file then that's bad, it should be in a .java file.
+Pie Number of slices to send: Send
yes, it is in .java class
Could you hold this kitten for a sec? I need to adjust this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 636 times.
Similar Threads
Service specific error 10
query issue
Result set type
Return a ResultSet from a model class?
Problem in getting the data from DB using servlets
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 04:34:11.