Re: [WebDNA] Dynamic vertical columns
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 100627
interpreted = N
texte = Sorry to be coming to this a little late, but I did this a few years ago, with very simple and straightforward code using only showif and ceil: http://3dcenter.us/thankyou.html?ind=t [search ...stuff...]
(header stuff in the first few rows) [founditems] | [first] [last] | [state] | [showif [index]=[math]ceil([numfound]/3)[/math]] | [/showif] [showif [index]=[math]ceil(2*[numfound]/3)[/math]] | |
[/search] Terry >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 01 | >COL 02 | >COL 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] >--------------------------------------------------------- >This message is sent to you because you are subscribed to >the mailing list
. >To unsubscribe, E-mail to: -- Terry Wilson | terry@terryfic.com | http://terryfic.com http://WhosComing.com - a simplified, affordable online reservation system http://TightJacket.com -- stylish protection for your laptop -------------------------------------------------------------------------- Attitude is the only difference between ordeal and adventure.
Associated Messages, from the most recent to the oldest:
Sorry to be coming to this a little late, but I did this a few years ago, with very simple and straightforward code using only showif and ceil: http://3dcenter.us/thankyou.html?ind=t [search ...stuff...] (header stuff in the first few rows) | [/showif] [showif [index]=[math]ceil(2*[numfound]/3)[/math]] | |
[/search] Terry >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 01 | >COL 02 | >COL 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] >--------------------------------------------------------- >This message is sent to you because you are subscribed to >the mailing list . >To unsubscribe, E-mail to: -- Terry Wilson | terry@terryfic.com | http://terryfic.com http://WhosComing.com - a simplified, affordable online reservation system http://TightJacket.com -- stylish protection for your laptop -------------------------------------------------------------------------- Attitude is the only difference between ordeal and adventure.
Terry Wilson
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:
Multiple edits/replacementsd to db. Possible? (1997)
Multiple catalog databases and showcart (1997)
[WebDNA] An alternative to hosting... (2009)
Help getting [shownext] to increment (2003)
Shared conversion under WebTen (1998)
Founditems Add/remove graphic display problem (1999)
newbie Q: [cart] documentation (1999)
suffix mapping for NT? (1997)
why is this line in GeneralStore? (1998)
Problem with Showif & Applescript (1997)
WebCat2: Found Items syntax, etc. (1997)
RE: OK, here goes... (1997)
$flushdatabases question ... (1998)
PDF template hell (2000)
emailer (1997)
Deleting Orders (1997)
Ampersand (1997)
Possible Hijacking from Globix (2002)
Cleaner URLs (2003)
[SearchString] problem with [search] context (1997)