Aceh: Perbedaan revisi

Baris 2: Baris 2:
 
   code,
 
   code,
 
   case when level < 5 then   
 
   case when level < 5 then   
     format ('<h%s>%s</h%s>',
+
     format ('<h%s>$s%s</h%s>',
 
     level,
 
     level,
 +
    repeat('&nbsp',level),
 
     name,
 
     name,
 
     level)
 
     level)
 
   else
 
   else
     format ('&nbsp;&nbsp;%s',
+
     format ('&nbsp;&nbsp;&nbsp;&nbsp;%s',
 
     name)  
 
     name)  
 
   end
 
   end
 
from locations where left(code,2) = '12' and not del order by code limit 10|Code, location}}
 
from locations where left(code,2) = '12' and not del order by code limit 10|Code, location}}

Revisi per 28 Agustus 2014 18.20

Code location
12

$s&nbsp&nbsp</hSumatera Utara>

1201

$s&nbsp&nbsp&nbsp</hNias>

120101

$s&nbsp&nbsp&nbsp&nbsp</hIdano Gawo>

12010101     Tete Goenaai
12010102     Laowo Hilimbaruzo
12010103     Hililawae
12010104     Tuhewaebu
12010105     Sisobahili Iraonohura
12010106     Hilimoasio
12010107     Oladano