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:

problems with 2 tags shakur (1997) Try not to laugh (2007) Possible Bug in 2.0b15.acgi (1997) Re:2nd WebCatalog2 Feature Request (1996) Error.html (1997) Template cache problem with WC4 on Mac OS X (2000) More than one db with the same namn (was: WC2f3) (1997) Setting up shop (1997) multiple search commands (1997) Still having install problems (2000) DrWatson Error! (1999) RE: Signal Raised (1997) [WebDNA] mac os for wc 6.0 (2008) Where is eudora plugin? (1998) Cart passing in URL.. (2004) Some Advise needed (1997) Satisfy Me ! was: Why can't support be satisfying to purchasers? (2000) sendmail spaces (1997) WebCat editing, SiteGuard & SiteEdit (1997) Friday Morning Funnies (2003)