Txtdb-sample4

Package version/links

pmwiki-2.3.13
Skin - notebook-nt
txtdb-2.2.1-alpha-2-20230215

Txtdb - Sql query using txtdb directives

  • Data source in 'Csv in wikipage' or 'PmWiki simple table'
  • Output as 'List/Wikilist'
  • Output behaviour 'Transpose'


Table(from PmWiki Simple Table) - Output(List)

(:txtdbSet id1 'Cookbook.Txtdb-sample3' mydb2:)
(:txtdbQuery id1 "SELECT * FROM GreekAlphabet LIMIT 5":)
(:txtdbDraw id1 list UseFirstAsKey=0:)
  • 0
    • zeta
    • eta
    • theta
    • iota
    • kappa
  • 1
    • lamda
    • mu
    • nu
    • xi
    • omikron
  • 2
    • pi
    • rho
    • sigma
    • tau
    • upsilon
  • 3
    • phi
    • chi
    • psi
    • omega
  • 4
    • alpha
    • beta
    • gamma
    • delta
    • epsilon

Table(from PmWiki Simple Table) - Output(List,Transpose)

(:txtdbSet id2 'Cookbook.Txtdb-sample3' mydb2:)
(:txtdbQuery id2 "SELECT * FROM GreekAlphabet LIMIT 5":)
(:txtdbDraw id2 wikilist transpose:)
  • col1
    • zeta
    • lamda
    • pi
    • phi
    • alpha
  • col2
    • eta
    • mu
    • rho
    • chi
    • beta
  • col3
    • theta
    • nu
    • sigma
    • psi
    • gamma
  • col4
    • iota
    • xi
    • tau
    • omega
    • delta
  • col5
    • kappa
    • omikron
    • upsilon
    • epsilon

Reference Table(from PmWiki Simple Table) - Output(table)

Recalling txtdbDraw with different options
(:txtdbDraw id2 table sortable id=id100:)
col1col2col3col4col5
zetaetathetaiotakappa
lamdamunuxiomikron
pirhosigmatauupsilon
phichipsiomega
alphabetagammadeltaepsilon


See page data source(1) | See page data source(2)

Edit - History - Print - Recent Changes - Search
Page last modified on November 08, 2022, at 11:38 AM