You are viewing a plain text version of this content. The canonical link for it is here.
Posted to taglibs-user@tomcat.apache.org by Francis <ff...@met.wallonie.be> on 2006/06/20 15:10:58 UTC
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: taglibs-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: taglibs-user-help@jakarta.apache.org
RE: Result with sql
Posted by Michael Atlas <MA...@basistech.com>.
<sql:query var="countQuery">
select count(*) as totalCount from table
</sql:query>
<c:out value="${countQuery.rows[0].totalCount}"/>
-----Original Message-----
From: Francis [mailto:ffraikin@met.wallonie.be]
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: taglibs-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: taglibs-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: taglibs-user-help@jakarta.apache.org