Package version/links:
pmwiki-2.2.5
Skin - pmwiki
txtdb-2.2.0-alpha-6-20100212
Txtdb - Sql query using txtdb directives
- Data source in Csv in wikipage and 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
- 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
- col2
- col3
- col4
- col5
- epsilon
- kappa
- omikron
- upsilon
|
Reference Table(From PmWiki Simple Table) - Output(table)
Recalling txtdbDraw with different options
(:txtdbDraw id2 table sortable id=id100:)
(:sortable:)
|
| col1 | col2 | col3 | col4 | col5 |
|---|
| alpha | beta | gamma | delta | epsilon |
| zeta | eta | theta | iota | kappa |
| lamda | mu | nu | xi | omikron |
| pi | rho | sigma | tau | upsilon |
| phi | chi | psi | omega | |
|