Re: Tree menu with pl/sql and html

From: <yuppie_at_interfree.it>
Date: 4 May 2005 02:01:42 -0700
Message-ID: <1115195398.476501.88030_at_o13g2000cwo.googlegroups.com>


Thanks a lot Mark!
I will try soon!

Bye
simo
Mark C. Stock ha scritto:
> "Simo" <yuppie_at_interfree.it> wrote in message
> news:f482699.0504100352.6eee711b_at_posting.google.com...
> > "Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message
> > news:<q62dnXux_JiyJMrfRVn-3Q_at_comcast.com>...
> >> "Simo" <yuppie_at_interfree.it> wrote in message
> >> news:f482699.0504082316.1b7f99ce_at_posting.google.com...
> >> > Hi!
> >> > Does anybody have implemented an html tree with hierarchy query
in
> >> > pl/sql
> >> > language?
> >> > I have the right query but i can't show it on html...
> >> >
> >> > Thanks a lot,
> >> > Simona
> >>
> >> pl/sql web toolkit or HTMLDB?
> >>
> >> this probably boils down to a DHTML question...
> >>
> >> ++ mcs
> >
> > Pl/sql web toolkit i mean....
> >
> > bye
> > simona

>
> what type of functionality in the browser are you looking for? do you
need
> the hierarchy to be dynamic in any way (links, expand/collapse)? how
> familiar are you with DHTML?

>

> basically, you're going to loop though your records and issue the
> appropriate DHTML tags via htp.p... here's an easy way:
>

> create or replace procedure tree_query
> as
> begin
> htp.p('<p>Tree Query Sample</p>');
>

> -- start HTML table
> --
> htp.p('<table>');
>
> -- loop thru hierarchical query
> --
> for r1 in (
> select level, ename, job, empno
> from emp
> connect by prior empno = mgr
> start with mgr is null
> )
> loop
> -- start HTML table row
> --
> htp.p('<tr>');
>
> -- generate empty cells for indent
> --
> for i in 2..r1.level
> loop
> htp.p('<td width=15>&nbsp;</td>');
> end loop;
>
> -- output row data in the final cell; use colspan so data
cell is
> not aligned with indent cells
> --
> htp.p('<td colspan=100>' || r1.ename || ' (' || r1.empno ||
') ' ||

> r1.job || '</td>');
>

> -- end HTML row
> --
> htp.p('</tr>');
> end loop;
>
> -- end HTML table
> --
> htp.p('</table>');
> end tree_query;
>
>
> ++ mcs
Received on Wed May 04 2005 - 11:01:42 CEST

Original text of this message