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:

    
  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)
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:

WebCat2 beta 11 - new prefs ... (1997) Possible Bug in 2.0b15.acgi (1997) Various Problems (1997) BBEdit and WebCatalog 2.0? (1997) Country & Ship-to address & other fields ? (1997) Counting LineItems (2000) Security Issues and WebCommerce Solution (1997) Un[url]ize (1999) Searching multiple Databases (1997) emailer truncates last letter! (1997) Still having problems with Authen (1997) Rhapsody? (1997) Linux vs Jaguar (OSX) (2002) reverse of math value... (2004) cart info (1998) passing cart value (2003) [Sum] function? (1997) [WebDNA] Nested Searches (2013) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) anyone moved to v6? (2004)