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:

Updating fields from different platforms (1998) Wanted: More Math Functions (or, Can You Solve This?) (1997) b12 cannot limit records returned and more. (1997) price carry over (1997) back button loses cart (update for ken) (2000) apostrophe in search item (1997) OT: Sending email to lots of subscribers (1999) Server IP address? (1998) [include] affect on filepaths for links? (1997) WebCatalog NT (1996) WebDNA for Dummies (2004) [ShowNext] (1997) more info on [setlineitems] (1997) RE: can we get string variables? (1998) Date search - yes or no (1997) Trigger to restart Webcat Service (2001) updating with ProductEditor (1998) [isfile] ? (1997) Line Feed problems ... (2002) Limiting user access to .tmpl files (1997)