tomcat-taglibs-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sgarlata Matt" <sgarlata_m...@bah.com>
Subject Re: How to add two integer using tag libs?
Date Fri, 08 Aug 2003 21:51:20 GMT
Try

<c:set var="all_active" scope="page" value="${offers.rows[0].OFFERS +
seeks.rows[0].SEEKS}" />

Matt
----- Original Message -----
From: "p@zdzior" <pazdzior@interia.pl>
To: <taglibs-user@jakarta.apache.org>
Sent: Friday, August 08, 2003 5:47 PM
Subject: How to add two integer using tag libs?


Hi,

I am trying to add two integer values obtained from the database,
here is what I am doing:

<sql:transaction dataSource="${jazda}">
  <sql:query var="seeks">
    SELECT COUNT(*) AS SEEKS FROM REQUEST_SEEK WHERE RS_FK_RS_ID =
'SMS_AUTH' || RS_FK_RS_ID = 'WWW_AUTH'
  </sql:query>
  <sql:query var="offers">
    SELECT COUNT(*) AS OFFERS FROM REQUEST_OFFER WHERE RO_FK_RS_ID =
'SMS_AUTH' || RO_FK_RS_ID = 'WWW_AUTH'
  </sql:query>
</sql:transaction>

<c:set var="all_active" scope="page" value="${offers.rows[0].OFFERS} +
${seeks.rows[0].SEEKS}" />

but I am receiving only string for example "34 + 65".
Is it possible to add these values and print the result?

I would be gratefull for any help,

regards,
Lukasz



Mime
View raw message