WebDB 2.2 Reports

From: Montse COLLADOS POLIDURA <Montse.Collados_at_cern.ch>
Date: Mon, 27 Mar 2000 09:49:49 +0200
Message-ID: <38DF129D.245CD0F5_at_cern.ch>



Hi,

[Quoted] I would like to get the number of rows returned when displaying the report results. Something like :



[Quoted] Report results title.

Number of rows returned: <number>

table with results...


I tried to do it usign PL/SQL but it does not recognize the bind variables. They are the same ones that I use to create the report.

select count(*) into num
from user1.table1
[Quoted] where name = :name_v and

      surname = :surname_v ;
htp.print('<H2>Number of rows returned: </H2>'|| num);

What am I doing wrong?
Is there any other way of doing so?

thanks for your time and help,
Montse Collados Polidura
CERN - Switzerland Received on Mon Mar 27 2000 - 09:49:49 CEST

Original text of this message