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 "Das, Amar" <Am...@tpmc.com> on 2003/06/11 23:29:37 UTC

Null values and no of rows

I have two questions.  Will appreciate your help.
1.  In the following example, how can I substitute NA for null values.  Note
that I do not construct the sql to include NVL function.  The SQL statement
is passed to me.
  <c:forEach var="row" items="${deejays.rowsByIndex}">
    <tr>
      <c:forEach var="column" items="${row}">
        <td><c:out value="${column}"/></td>
      </c:forEach>
    </tr>
  </c:forEach>
2.  In the following example, how do I know how many rows returned?
  <sql:query var="deejays">
    SELECT * FROM mytable
  </sql:query>

Thank you,
Amar Das

Perot Systems - Government Services
Voice: 781.545.2697
       207.594.3007


---------------------------------------------------------------------
To unsubscribe, e-mail: taglibs-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: taglibs-user-help@jakarta.apache.org