Yes, use a fixed font (Courier) and padd the indents with You must write a special formatter class to do the work...
Regards, Henner > -----Urspr�ngliche Nachricht----- > Von: Lazaro Fung [mailto:[EMAIL PROTECTED] > Gesendet: Samstag, 1. M�rz 2003 16:00 > An: Henner Kollmann > Cc: dbf > Betreff: Re: [dbforms] Hierarchical Output in combo box > > > Hi Henner > > Thanks for your reply > > Your solution works perfect. > > But do you have any ideas to indent the query results in th combo ? > > Water > Ozono > Ultra Pure > Cleaning > Kitchen > Bathroom > > TIA > > LFung > > ----- Original Message ----- > From: "Henner Kollmann" <[EMAIL PROTECTED]> > To: "'Lazaro Fung'" <[EMAIL PROTECTED]> > Cc: "dbf" <[EMAIL PROTECTED]> > Sent: Saturday, March 01, 2003 3:47 AM > Subject: AW: [dbforms] Hierarchical Output in combo box > > > > Yes, rearange your data: > > > > categoryId pcategoryId category > > 1 1 Water > > 2 1 Ozone > > 3 1 Ultra Pure > > 4 4 Cleaning > > 5 4 Kitchen > > 6 4 Bathroom > > > > And write select category from category order by pcategoryID, > > categoryId > > > > Regards, > > Henner > > > > > -----Urspr�ngliche Nachricht----- > > > Von: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] Im Auftrag > > > von Lazaro Fung > > > Gesendet: Freitag, 28. Februar 2003 23:57 > > > An: [EMAIL PROTECTED] > > > Betreff: [dbforms] Hierarchical Output in combo box > > > > > > > > > Hi. > > > > > > I have this table in MySQL > > > > > > CREATE TABLE `category` ( > > > `categoryId` int(4) NOT NULL auto_increment, > > > `pcategoryId` int(4) NOT NULL default '0', > > > `category` varchar(50) NOT NULL default '', > > > PRIMARY KEY (`categoryId`) > > > ) TYPE=MyISAM > > > > > > to represent a hierarchical category > > > > > > categoryId pcategoryId category > > > 1 0 Water > > > 2 1 Ozone > > > 3 1 Ultra Pure > > > 4 0 Cleaning > > > 5 4 Kitchen > > > 6 4 Bathroom > > > > > > I need need to set a categoryId to a product in the table > > > > > > CREATE TABLE `product` ( > > > `productId` int(4) NOT NULL auto_increment, > > > `product` varchar(200) NOT NULL default '', > > > `description` text, > > > `categoryId` int(4) NOT NULL default '0', > > > PRIMARY KEY (`productId`) > > > ) TYPE=MyISAM > > > > > > I need to setup a combo with all the categories but ordered as : > > > > > > Water > > > Ozono > > > Ultra Pure > > > Cleaning > > > Kitchen > > > Bathroom > > > > > > Note: the category table not are in this order. > > > > > > Any ideas ? > > > > > > Sincerely > > > > > > LFung > > > > > > > > > > > > ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
