<sql:query var="countQuery">
select count(*) as totalCount from table
</sql:query>
<c:out value="${countQuery.rows[0].totalCount}"/>
-----Original Message-----
From: Francis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 20, 2006 9:11 AM
To: Tag Libraries Users List
Subject: Result with sql
How to retrieve one result from a sql:query whitout a foreach?
For instance "select count(*) from table" in the var nbr.
Francis
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
