DB tags dealing with an empty result set...(sql printed as html)

[Rajesh Kalluri manduca]

Hi All,

My jsp using dbtags is printing out the sql query on to the browser as html
when my result set is null, i have attempted to deal with ti  in the
following way with no use:

<sql:preparedStatement id="stmt4" conn="conn1">
  <sql:query>
    select id, url, title from view_daily_content where
ARTICLETYPE='AVANCES' and CHANNEL='CARACAS'
  </sql:query>
  <sql:resultSet id="rset4">

  <sql:wasNotEmpty>
    <tr >
        <td>
           <input type="checkbox" name="noticia" value="<sql:getColumn
position="1"/>">
           <a href="<sql:getColumn position="2"/>"><sql:getColumn
position="3"/></a>
        </td>
    </tr>
  </sql:wasNotEmpty>
  </sql:resultSet>
    <sql:wasEmpty><b><i>No Artciles published in this category
yet</i></b></sql:wasEmpty>
</sql:preparedStatement>

This is the html output

select id, url, title from view_daily_content where ARTICLETYPE='AVANCES'
and CHANNEL='CARACAS' No Artciles published in this category yet

Did any oen deal with this issue before.

Thanks a lot.

Rajesh


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