Cookbook /
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:) |
|
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:) |
|
Reference Table(from PmWiki Simple Table) - Output(table)
Recalling txtdbDraw with different options
(:txtdbDraw id2 table sortable id=id100:) | ||||||||||||||||||||||||||||||
|