File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JSP and the fly likes check sql:query for no data Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
Bookmark "check sql:query for no data" Watch "check sql:query for no data" New topic
Author

check sql:query for no data

liliya woland
Ranch Hand

Joined: Apr 11, 2006
Posts: 134
Hello,
Could someone please tell if there is a way to check if the sql command below produces any data or not? I'd like to be able to tell the jsp user that there is no data when the sql command returns no data. Thanks in advance.
liliya woland
Ranch Hand

Joined: Apr 11, 2006
Posts: 134
I got the testing for no data to work with the following code:
 
Don't get me started about those stupid light bulbs.
 
subject: check sql:query for no data
 
Similar Threads
How to get a connection from the connection pool in a servlet
problem with JSTL
how to get the value in the text area (jsp)
simple select returns null
Inconsistent results with sql:param