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] Report results title.
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