Package version/links:
pmwiki-2.2.5
Skin - pmwiki
txtdb-2.2.0-alpha-6-20100212
Help
Syntax for dataquery and output within wikipages
- (:txtdbSet ID 'Group.Name' DatabaseName:)
- ID is the unique ID per database call.
- Group.Name - wikipage where database resides.
- DatabaseName - Name of the database.
- (:txtdbQuery ID "SelectQuery":)
- ID is the unique ID per database call.
- SelectQuery - Sql query.
- (:txtdbDraw ID OutputType OutputBehaviour Options :)
- ID is the unique ID per database call.
- OutputType - table | wikitable | list | wikilist | pagevar | sessionvar | array | serialize
- table - html output
- wikitable - pmwiki simple table markup output
- list - html list output
- wikilist - pmwiki list markup output
- pagevar - set page variables
- sessionvar - set session variables
- array - raw output as array
- serialize - raw serialized output
- OutputBehaviour
- sortable - for [table|wikitable] (adds css class sortable to the table)
- transpose - for all OutputType
- Options
- for pagevar|sessionvar - [prefix=varprefix] (prefix for variables names)
- for table|wikitable - [id=abc] (css Id for ouput)
- for table|wikitable|list - [class=xyz] (css class for ouput)
- for list|wikilist - [UseFirstAsKey=0|1] (makes first data from list primary)
- (:txtdbPageVar:) ..... (:txtdbPageVarEnd:)
- for pagevar|sessionvar - when output as 'pagevar,sessionvar' in 'txtdbDraw',
the Set/Query/Draw calls needs to be encapsulated by this directive.
- FORM/s posting
- txtdbFrmId - ID field(fixed,required) for db call
- dbpage - is name/value to be used while posting 'Group.Name'
- dbname - is name/value to be used while posting 'DatabaseName'
- query - is name/value to be used while posting 'SelectQuery'
- txtdbSubmit - submit button name(fixed,required)
- Output from forms...
- (:txtdbDraw TxtDbId1 .... :) - (can be used except for 'pagevar,sessionvar' output)
- (:txtdbDrawVar TxtDbId1 pagevar|sessionvar [prefix=txtdb] :) - (for 'pagevar,sessionvar' output)
Syntax for database/data table in wikipages