Re: [WebDNA] Dynamic vertical columns
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 100643
interpreted = N
texte = Chris it all depends on the remainder when [numfound]/4 if you have remainder of 0 when numfound=60 15 | 15 | 15 | 15 if you have remainder of 1 when numfound=61 16 | 15 | 15 | 15 if you have remainder of 2 when numfound=62 16 | 15 | 16 | 15 if you have remainder of 3 when numfound=63 16 | 16 | 16 | 15 This is the code I use to test ThisTotal=[Math]ThisTotal=61[/Math]
remainder=[Math]remainder=[ThisTotal]%4[/Math]
[Search db=^data/ species.db&neSACTIVEdatarq=ALL&asSCOMMONNAMEsort=1&max=[ThisTotal]]
[foundItems] [index] - [scommonname]
[showif [index]=[math]ceil([ThisTotal]/4)[/math]] | [/ showif] [showif [index]=[math]ceil([ThisTotal]/2)[/math]] | [/ showif] [showif [index]=[math]ceil([ThisTotal]-([ThisTotal]/4))[/math]] | [/showif] [/foundItems] |
[/search] Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 03/09/2008, at 11:13 AM, PLANET DJ (Chris W.) wrote: > Well, you're correct that mine is for 4 columns, not 3 as I > originally stated. > > Mine is currently displaying as 44 | 44 | 44 | 43. I know this total > number (175) has changed, and I also have never seen col2 shorter > than col1 or col3. Maybe I'll watch that in the future and see what > happens. > > Best Regards, > > Chris Whybrew > Senior Account Manager > > > PLANET DJ INC > www.planetdj.com > > p: 775.323.1540 ext 3903 > f: 775.323.8230 > e: chrisw@planetdj.com > > > From: "Stuart Tremain"
> Sent: Tuesday, September 02, 2008 2:24 PM > To: talk@webdna.us > Subject: Re: [WebDNA] Dynamic vertical columns > > Chris > > That code is similar to Terry's, yours is for 4 columns. > > Both these methods leave uneven numbers in the columns is your > [numfound] is not exactly divisible by 4, for instance if you have 70 > found items you will get columns of: > > 18 | 17 | 18 | 17 > > The method I posted will give you > > 18 | 18 | 18 | 16 > > It depends on how you like the columns to fall > > > > > > > On 03/09/2008, at 2:28 AM, PLANET DJ (Chris W.) wrote: > > > Well, mine's coded like this for 3 columns: > > > > [search...] > > > > > > > > > [foundItems] > > [field1] > > > [showif [index]=[math]ceil([numFound] / 4)[/math]] > > > valign=top>[/showif] > > [showif [index]=[math]ceil([numFound] / 2)[/math]] > > > valign=top>[/showif] > > [showif [index]=[math]ceil([numFound]-([numFound] / 4))[/math]] > > td> > [/showif] > > [/foundItems] > > > > > > > [/search] > > > > Best Regards, > > > > Chris Whybrew > > Senior Account Manager > > > > > > PLANET DJ INC > > www.planetdj.com > > > > p: 775.323.1540 ext 3903 > > f: 775.323.8230 > > e: chrisw@planetdj.com > > > > > > From: "Stuart Tremain" > > Sent: Sunday, August 31, 2008 5:16 PM > > To: talk@webdna.us > > Subject: [WebDNA] Dynamic vertical columns > > > > Start of Spring here in Aus today - at last :) > > > > I know how to build dynamic tables where the results are posted > > horizontally. Does anyone have a trick for building the columns > > vertically? > > > > From this: > > > > HEAD01 | HEAD02 | HEAD03 | HEAD04 > > 01 | 02 | 03 | 04 > > 05 | 06 | 07 | 08 > > > > > > to this: > > > > HEAD01 | HEAD02 | HEAD03 | HEAD04 > > 01 | 03 | 05 | 07 > > 02 | 04 | 06 | 08 > > > > > > > > > > Regards > > > > Stuart Tremain > > IDFK Web Developments > > AUSTRALIA > > webdna@idfk.com.au > > > > > > > > > > --------------------------------------------------------- > > This message is sent to you because you are subscribed to > > the mailing list . > > To unsubscribe, E-mail to: > > > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: >
Associated Messages, from the most recent to the oldest:
Chris it all depends on the remainder when [numfound]/4 if you have remainder of 0 when numfound=60 15 | 15 | 15 | 15 if you have remainder of 1 when numfound=61 16 | 15 | 15 | 15 if you have remainder of 2 when numfound=62 16 | 15 | 16 | 15 if you have remainder of 3 when numfound=63 16 | 16 | 16 | 15 This is the code I use to test ThisTotal=[math]ThisTotal=61[/Math]
remainder=[math]remainder=[ThisTotal]%4[/Math]
[Search db=^data/ species.db&neSACTIVEdatarq=ALL&asSCOMMONNAMEsort=1&max=[ThisTotal]] [founditems] [index] - [scommonname]
[showif [index]=[math]ceil([ThisTotal]/4)[/math]] | [/ showif] [showif [index]=[math]ceil([ThisTotal]/2)[/math]] | [/ showif] [showif [index]=[math]ceil([ThisTotal]-([ThisTotal]/4))[/math]] | [/showif] [/foundItems] |
[/search] Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 03/09/2008, at 11:13 AM, PLANET DJ (Chris W.) wrote: > Well, you're correct that mine is for 4 columns, not 3 as I > originally stated. > > Mine is currently displaying as 44 | 44 | 44 | 43. I know this total > number (175) has changed, and I also have never seen col2 shorter > than col1 or col3. Maybe I'll watch that in the future and see what > happens. > > Best Regards, > > Chris Whybrew > Senior Account Manager > > > PLANET DJ INC > www.planetdj.com > > p: 775.323.1540 ext 3903 > f: 775.323.8230 > e: chrisw@planetdj.com > > > From: "Stuart Tremain" > Sent: Tuesday, September 02, 2008 2:24 PM > To: talk@webdna.us > Subject: Re: [WebDNA] Dynamic vertical columns > > Chris > > That code is similar to Terry's, yours is for 4 columns. > > Both these methods leave uneven numbers in the columns is your > [numfound] is not exactly divisible by 4, for instance if you have 70 > found items you will get columns of: > > 18 | 17 | 18 | 17 > > The method I posted will give you > > 18 | 18 | 18 | 16 > > It depends on how you like the columns to fall > > > > > > > On 03/09/2008, at 2:28 AM, PLANET DJ (Chris W.) wrote: > > > Well, mine's coded like this for 3 columns: > > > > [search...] > > > > > > > > > [founditems] > > [field1] > > > [showif [index]=[math]ceil([numFound] / 4)[/math]] > > > valign=top>[/showif] > > [showif [index]=[math]ceil([numFound] / 2)[/math]] > > > valign=top>[/showif] > > [showif [index]=[math]ceil([numFound]-([numFound] / 4))[/math]] > > td> > [/showif] > > [/foundItems] > > > > > > > [/search] > > > > Best Regards, > > > > Chris Whybrew > > Senior Account Manager > > > > > > PLANET DJ INC > > www.planetdj.com > > > > p: 775.323.1540 ext 3903 > > f: 775.323.8230 > > e: chrisw@planetdj.com > > > > > > From: "Stuart Tremain" > > Sent: Sunday, August 31, 2008 5:16 PM > > To: talk@webdna.us > > Subject: [WebDNA] Dynamic vertical columns > > > > Start of Spring here in Aus today - at last :) > > > > I know how to build dynamic tables where the results are posted > > horizontally. Does anyone have a trick for building the columns > > vertically? > > > > From this: > > > > HEAD01 | HEAD02 | HEAD03 | HEAD04 > > 01 | 02 | 03 | 04 > > 05 | 06 | 07 | 08 > > > > > > to this: > > > > HEAD01 | HEAD02 | HEAD03 | HEAD04 > > 01 | 03 | 05 | 07 > > 02 | 04 | 06 | 08 > > > > > > > > > > Regards > > > > Stuart Tremain > > IDFK Web Developments > > AUSTRALIA > > webdna@idfk.com.au > > > > > > > > > > --------------------------------------------------------- > > This message is sent to you because you are subscribed to > > the mailing list . > > To unsubscribe, E-mail to: > > > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: >
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:
RE: Displaying Location (1997)
Old $ commands and migration (2004)
Summing fields (1997)
Tax and Shipping Examples (1997)
Re: (1998)
Only charge card when product shipped ? (1997)
Is using [URL] recommended even on an email address? (1999)
HTTP header line is too long? (1997)
wc 2 pro users - sites, quotes wanted (1997)
Emailer setup (1997)
Netscape Error Message Document Contains No Data (1998)
Separate SSL Server (1997)
quantity minimum problem (1997)
webcat NT with [dos] command (1997)
[WebDNA] a major shift in strategy? (2008)
[shownext max=?] armed (1997)
WebMerchant 1.6 and https (1997)
quantity minimum problem (1997)
CMSBuilder (2004)
[ShowNext] (1997)