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:
Webstar 1.3.1 PPC (1997)
Random Generator (2005)
New command suggestion (was Modifying databasesmanually) (1997)
Instructions for Digest (1997)
detecting already used [cart]? (2005)
Another question (1997)
popups, netscape vs explorer (1997)
WebCatalog can't find database (1997)
Who is doing sign-ups-got it (1998)
Not really WebCat (1997)
Upload to LINUX always breaks my sites - why? (2004)
RE: Problems with shopping cart (1997)
multiple product databases (1997)
Search wbrk word break param (1998)
WebCatalog2 Feature Feedback (1996)
[ShowIf] and empty fields (1997)
RAM variables (1997)
# fields limited? (1997)
Missing custom convert.db (1998)
unable to launch acgi in WebCat (1997)