How to check the <sql:query> is return null value

I have use :

<sql:query var="sql1" dataSource="${db}">

select col_name from table_name

where a=<c:out value="${row.test1}"/>

and b='<c:out value="${row.test2}"/>'

</sql:query>

So, how can I check this statement return null value which is no record within this table?

[337 byte] By [kellychanhya] at [2007-10-2 5:05:29]

# 1

The Result should never be null but can be empty. You can check if the Result is empty using an if tag and checking the rowCount property:

<sql:query var="books"

sql="select * from PUBLIC.books where id = ?" >

<sql:param value="${bookId}" />

</sql:query>

<c:if test="${books.rowCount > 0}">

..........

</c:if>

http://java.sun.com/j2ee/1.4/docs/tutorial/doc/JSTL7.html#wp84217

Look for query Tag Result Interface

tolmanka at 2007-7-16 1:08:51 >

Enterprise & Remote Computing New Topic