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:
WC2f3 (1997)
[Replace] (2000)
weird G3 happenings (1998)
IE Cache Problems... (1999)
Forumulas.db & Variables (2002)
[WebDNA] TLS 1.2 and [tcpconnect] (2018)
Using WebMerchant Only? (1998)
why is this line in GeneralStore? (1998)
Need help with form (1998)
Non Standard Product Display Layout (2000)
creating a ShipCosts database (1997)
[shownext] and sort (1998)
hmmm (2006)
OT: Amazon Patents (2000)
Bug Report, maybe (1997)
Frames (1997)
Exclamation point (1997)
Q: for those who use Cookies for sessions? (2004)
Order not created error (never mind) (1997)
Help! Missing [showif] or [hideif] (2000)