List: | General Discussion | « Previous MessageNext Message » | |
From: | hsv | Date: | May 25 2012 1:35pm |
Subject: | Re: category with parentid | ||
View as plain text |
>>>> 2012/05/25 14:57 +0700, HaidarPesebe >>>> id | name | parentid ---------------------- 1 | cat A | 0 2 | cat B | 0 3 | subcat A | 1 4 | subcat A | 1 5 | subncat B | 2 ------------------------- I want to display the result like this: 1. Cat A - Subcat A - Subcat A 2. CatB - Subcat B <<<<<<<< If the degree of subordination is a number in your record, try function REPEAT (output concatenated to A or B), or LPAD. ************************************************************** Scanned by MailScan AntiVirus and Content Security Software. Visit http://www.escanav.com for more info on eScan and X-Spam. **************************************************************
Thread | ||
---|---|---|
• category with parentid | HaidarPesebe | 25 May |
• Re: category with parentid | hsv | 25 May |
• Re: category with parentid | Andrés Tello | 25 May |
• Re: category with parentid | (Roberta Jaskólski) | 26 May |
• Re: category with parentid | Peter Brawley | 25 May |
• Re: category with parentid | HaidarPesebe | 28 May |
• Re: category with parentid | Tsubasa Tanaka | 28 May |
• Re: category with parentid | hsv | 28 May |
• Re: category with parentid | (Roberta Jaskólski) | 28 May |
• Re: category with parentid | HaidarPesebe | 30 May |
• Re: category with parentid | HaidarPesebe | 30 May |
• Re: category with parentid | Tsubasa Tanaka | 30 May |