Re: [WebDNA] Dynamic vertical columns

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 100625
interpreted = N
texte = Well thanks to everyone for their thoughts and to Toby who brought modulus % to my attention, this flicked the switch for me, after 10 years at WebDNA I had never used it or even knew it existed. Here is my answer, it works for 3 columns and if you fiddle with the switches you will make it work for other numbers of columns. [Search db=^data/species.db&neSACTIVEdatarq=ALL&asSCOMMONNAMEsort=1] NumFound = [NumFound]
remainder=[Math]remainder=[NumFound]%3[/Math]
percolumn=[Math]percolumns=floor([NumFound]/3)[/Math]
totalpercolumn=[Math]totalpercolumn=[Switch value=[remainder]][Case value=2]1[/Case][Case value=1]1[/Case][Default]0[/Default][/Switch] + [percolumns][/Math]
COL 01COL 02COL 03
[FoundItems][ShowIf [Index]<[math][totalpercolumn]+1[/ math]][index] - [scommonname]
[/ShowIf][/FoundItems]		[FoundItems][If ([Index]>[Math][totalPERCOLUMN][/ Math])&([Index]<[math][NumFound]-[totalPERCOLUMN]+[Switch value=[remainder]][Case value=2]2[/Case][Case value=1]3[/Case][Case value=0]1[/Case][Default]0[/Default][/Switch][/math])][then][index] - [scommonname]
[/Then][/If][/FoundItems]		[FoundItems][ShowIf [Index]>[Math][NumFound]- [totalpercolumn]+[Switch value=[remainder]][Case value=2]2[/Case][Case value=1]2[/Case][Default]0[/Default][/Switch][/Math]][index] - [SCOMMONNAME]
[/ShowIf][/FoundItems]
[/Search] Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Dynamic vertical columns ("PLANET DJ (Chris W.)" 2008)
  2. Re: [WebDNA] Dynamic vertical columns (Stuart Tremain 2008)
  3. Re: [WebDNA] Dynamic vertical columns ("PLANET DJ (Chris W.)" 2008)
  4. Re: [WebDNA] Dynamic vertical columns (Stuart Tremain 2008)
  5. re: [WebDNA] Dynamic vertical columns ("PLANET DJ (Chris W.)" 2008)
  6. Re: [WebDNA] Dynamic vertical columns (Terry Wilson 2008)
  7. Re: [WebDNA] Dynamic vertical columns (Patrick McCormick 2008)
  8. Re: [WebDNA] Dynamic vertical columns (Stuart Tremain 2008)
  9. Re: [WebDNA] Dynamic vertical columns (Terry Wilson 2008)
  10. Re: [WebDNA] Dynamic vertical columns (Terry Wilson 2008)
  11. Re: [WebDNA] Dynamic vertical columns (Stuart Tremain 2008)
  12. Re: [WebDNA] Dynamic vertical columns (Stuart Tremain 2008)
  13. Re: [WebDNA] Dynamic vertical columns (Stuart Tremain 2008)
  14. Re: [WebDNA] Dynamic vertical columns (Stuart Tremain 2008)
  15. Re: [WebDNA] Dynamic vertical columns (Toby Cox 2008)
  16. Re: [WebDNA] Dynamic vertical columns (Paul Willis 2008)
  17. Re: [WebDNA] Dynamic vertical columns (Palle Bo Nielsen 2008)
  18. Re: [WebDNA] Dynamic vertical columns (Stuart Tremain 2008)
  19. Re: [WebDNA] Dynamic vertical columns (Palle Bo Nielsen 2008)
  20. Re: [WebDNA] Dynamic vertical columns (Stuart Tremain 2008)
  21. Re: [WebDNA] Dynamic vertical columns ("Dan Strong" 2008)
  22. RE: [WebDNA] Dynamic vertical columns ("Will Starck" 2008)
  23. [WebDNA] Dynamic vertical columns (Stuart Tremain 2008)
Well thanks to everyone for their thoughts and to Toby who brought modulus % to my attention, this flicked the switch for me, after 10 years at WebDNA I had never used it or even knew it existed. Here is my answer, it works for 3 columns and if you fiddle with the switches you will make it work for other numbers of columns. [Search db=^data/species.db&neSACTIVEdatarq=ALL&asSCOMMONNAMEsort=1] NumFound = [NumFound]
remainder=[math]remainder=[NumFound]%3[/Math]
percolumn=[math]percolumns=floor([NumFound]/3)[/Math]
totalpercolumn=[math]totalpercolumn=[Switch value=[remainder]][Case value=2]1[/Case][Case value=1]1[/Case][Default]0[/Default][/Switch] + [percolumns][/Math]
COL 01COL 02COL 03
[founditems][ShowIf [Index]<[math][totalpercolumn]+1[/ math]][index] - [scommonname]
[/ShowIf][/FoundItems]		[founditems][If ([Index]>[math][totalPERCOLUMN][/ Math])&([Index]<[math][NumFound]-[totalPERCOLUMN]+[Switch value=[remainder]][Case value=2]2[/Case][Case value=1]3[/Case][Case value=0]1[/Case][Default]0[/Default][/Switch][/math])][then][index] - [scommonname]
[/Then][/If][/FoundItems]		[founditems][ShowIf [Index]>[math][NumFound]- [totalpercolumn]+[Switch value=[remainder]][Case value=2]2[/Case][Case value=1]2[/Case][Default]0[/Default][/Switch][/Math]][index] - [SCOMMONNAME]
[/ShowIf][/FoundItems]
[/Search] Stuart Tremain

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

WebMerchant crashing and other WebMerchant problem (2000) no global [username] or [password] displayed ... (1997) WebDNA Solutions ... sorry! (1997) Not really WebCat (1997) About WebCatalog and iTools 7 (2003) WebCatalog [FoundItems] Problem - AGAIN - (1997) Problem with Showif & Applescript (1997) Summary layout (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) suggestion (1997) Initiating NewCart (1997) Spiders and Bots (2000) RE: Template Not Found (1998) Support suggestions - Response (2000) possible, WebCat2.0 and checkboxes-restated (1997) TeaRoom Search page (2000) Emailer Problem (1999) Problems problems problems (1997) GuestBook example (1997) Change in Host? (1999)