Welcome, Guest • Login
Jump to <root>CustomizeDevHelp

• Download
• Help + Forum
• Customize
• Develop
• Blog
• ScrewTurn Wiki Hosting

• Plugins and Providers
• Themes
  

Discuss (0) View Page Code History Attachments

Print

RSS

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¶

No Messages for this Page. Be the first!

	Name	Size
	Plugin.png	4.26 KB