Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Need help in creating a tree page in htmldb
Need help in creating a tree page in htmldb [message #138604] Thu, 22 September 2005 11:17
Peter75
Messages: 1
Registered: September 2005
Junior Member
How do I make a tree page of this data?

create table Flatfile
(Pgroup varchar2(30),
Pclass varchar2(30),
Manufacturer varchar2(30),
Article varchar2(30),
Price Number(6,2));

Insert into Flatfile Values
('Application Software','Database Software','Oracle','Oracle 10G',115);
Insert into Flatfile Values
('Application Software','Database Software','Microsoft','MS SQL Server 2000',200);
Insert into Flatfile Values
('Application Software','Spreadsheet Software','Microsoft','Excel',100);
Insert into Flatfile Values
('Monitor','15"','Acer','Acer 15"" TFT superscreen',199);
Insert into Flatfile Values
('Monitor','15"','Sony','Sony R1500 flat',225);
Insert into Flatfile Values
('Monitor','17"','Philips','Philips Flatscreen',250);
Insert into Flatfile Values
('Monitor','19"','Viewsonic','Viewsonic PLasma Monitor',275);
Insert into Flatfile Values
('Processor','AMD','AMD','FX-55',600);
Insert into Flatfile Values
('Processor','Intel','Intel','P4 3 GHZ',399);

I tried alot, but simply can't figure it out, please help:

A fixed level of two or three would be fine. I just don't understand the concept in creating one in htmldb. So:

Pgroup
---Pclass

Or

Pgroup
---Pclass
------Manufacturer

How must my query be written? How to normalize the data etc to be functional in the tree page wizard?

What do I fill in for these parameters:
*******************************************************
Identify Query - You do not code the query. Instead, you identify the following:
*******************************************************
ID - The primary key column of the table that is then used as the foreign key reference.
Parent ID - The foreign key column of the table that references the primary key column, thus forming the hierarchy.
Leaf Node Text - Select the column to display. Although this is a singular selection, you can edit the resulting query after it is defaulted to concatenate in other columns.
Link Option - If the tree is for informational purposes only, a Link Option is not necessary. If the tree will be used for navigation, select Existing Application Item.


Sincere,

Peter
Previous Topic: invalid object
Next Topic: ORA-00903: invalid table name
Goto Forum:
  


Current Time: Tue Feb 20 20:48:09 CST 2024