Re: How to add two integer using tag libs?

[Sgarlata Matt]

Try

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

Matt
----- Original Message -----
From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]