tomcat-taglibs-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gisella Saavedra" <gisel...@yachay.net>
Subject RE: extending JSTL
Date Tue, 03 Sep 2002 04:33:19 GMT
Shawn,
	thank you for the information.  I've got your book in e-format.
	It has been very useful.

-----

The query should return 0 rows.  But:
I get NO errors for the query.  
I get the rendered text "Some rows." and
no value for "Rows retrieved=".

This is my code (there is redundancy because I was trying to
trace the value of rowCount):

<c:catch var="queryError" >
        <sql:query var="hdf" scope="session" maxRows="100">
          SELECT CONVERT(char(12), orderDate, 100) dOrderDate,
               CAST(MCVisaSum AS decimal(16,2)) dCVisaSum, 
               CAST(DiscoverSum AS decimal(16,2)) dDiscoverSum,
               CAST(AMEXSum AS decimal(16,2)) dAMEXSum,
               CAST((MCVisaSum + DiscoverSum + AMEXSum) 
			AS decimal(16,2)) dTOTAL
          FROM v_dailyFlash
          WHERE orderTypeCode = ?
          AND customerCode = ?
          <sql:param value="${param.orderType}"/>
          <sql:param value="${sessionScope.consultantCode}"/>
        </sql:query>
      </c:catch>
      <c:if test="${not empty queryError}">
        <p>Sorry, it seems that this is not an acceptable query.
           <c:out value="${queryError.message}" /></p>
      </c:if>
    </c:if>
    <c:choose>
      <c:when test="${hdf.rowCount == 0}">
        <c:out value="No rows." />
      </c:when>
      <c:otherwise>
        <c:out value="Some rows." />
      </c:otherwise>
    </c:choose>
   <p>Rows retrieved=<c:out value="${hdf.rowCount}" /></p>



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


Mime
View raw message