ScrewTurn Wiki 4 Releases and News
Screwturn Compatible Hosting – Click Here for 3 Months Free!
G+ Twitter          Search: »
Amanuens
ScrewTurn Wiki
Image
Image
Version0.9.0
Rating
DeveloperFranz Fiala
UpdatedMay 24, 2011
HomepagePlugIn SQL Table Formatter Extended
Works withScrewTurn Wiki v3.0.x
LicenseGPLv2

More about this Plugin

An extended version of the SQL Table Formatter from Scott Clewell/Ezequiel Santamaria.

The following enhancements has been made to SQL Table Formatter:

  • parameters in SQL command
  • default values for parameters
  • autogenerate parameter lists
  • paging
  • alpha paging
  • multiple connection strings
  • display data of a single record in a vertical table

This new version should not change existing programs. It only extends the parameter set within the TableFormatter.

Example Parameter

Markup

{QueryTable 
  border-style="none" 
  cell-border-style="none" 
  noheaders
  category="CATEGORY,Amtsgebäude,BUILDINGS,(NOT (YEARFROM IS NULL)) AND (NOT (NAME IS NULL))" 
}
SELECT YEARFROM As Gebaut, NAME AS Gebäude 
FROM BUILDINGS 
WHERE 
  (NOT (YEARFROM IS NULL)) 
  AND (NOT (NAME IS NULL)) 
  AND (CATEGORY='@par@Amtsgebäude@')
ORDER BY YEARFROM, NAME
{/QueryTable}

Result

Amtsgebäude(2) Bildung(9) Brauerei(3) Brücke(24) Cafe(27) Denkmal(18) Energieversorgung(10) Entsorgung(8) Feuerwehr(4) Flussregulierung(5) Freiraum(7) Freizeit(15) Friedhof(2) Gaststätte(2) Geldwirtschaft(3) Gemeindebau(173) Geschäftsgebäude(36) Gesundheit(49) Grünanlage(4) Hotel(13) Justizgebäude(2) Kino(3) Kirche(2) Kunst(2) Markt(1) Medien(2) Militär(19) Musik(9) Öffi(69) Sakralbau(7) Schiff(1) Schloss(2) Sport(15) Sternwarte(3) Turm(11) Veranstaltungsraum(2) Verkehrsanlage(1) Villa(14) Wasserversorgung(11) Wohnungsbau(24)

Category='Amtsgebäude'
1883 Rathaus
1913 Bezirksmuseum Hernals

Try this Example

Example Alpha Paging

Markup

{QueryTable 
  border-style="none" cell-border-style="none" 
  noheaders
  alphapaging="NAME,BUILDINGS,(NOT (YEARFROM IS NULL)) AND (NOT (NAME IS NULL))"
}
SELECT 
  YEARFROM As Gebaut, 
  NAME As Gebäude 
FROM BUILDINGS 
WHERE 
  (NOT (YEARFROM IS NULL)) 
  AND (NOT (NAME IS NULL)) 
  AND (SUBSTRING(NAME,1,1))='@alpha@A@'
ORDER BY NAME
{/QueryTable}

Result

A(34) B(26) C(27) D(24) E(15) F(30) G(29) H(50) I(3) J(21) K(41) L(18) M(26) N(6) O(9) Ö(1) P(27) Q(1) R(32) S(73) T(18) U(34) V(27) W(32) Z(10)
1933 Adelheid-Popp-Hof
1925 Aïda
1964 Albertina Passage
2003 Albertina Rampe
1991 Albert-Schultz-Halle
...

Try this Example




Discuss

No Messages for this Page. Be the first!

  Name Size
- Plugin.png 4.26 KB

Side Projects

  • RESX Synchronizer allows to synchronize multi-language .resx files (used for the development of ScrewTurn Wiki).
  • Pixel Picker enables to pick the color of pixels on your screen — very handy for day-to-day graphics-related activities.

About

  • See our Privacy Policy.
  • Powered by ScrewTurn Wiki 3.0.5.613.
  • This namespace contains 45 pages.