Re: Showing Results Alphabetically in Columns (top to bottom)

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 46223
interpreted = N
texte = Kimberly-Look at the code I posted late last night.It won't break with an odd number of cells.Here is what I get with 11 records: 1-Abby 4-Dave 7-Gabe 2-Bob 5-Ed 8-Harold 3-Carl 6-Frank 9-Jack 4-Dave 7-GabeHere's the example: http://www.novaderm.com/test/tabletest.tplWill Starck NovaDerm Skincare Science http://www.novaderm.com wjs@novaderm.comLook On Wednesday, December 11, 2002, at 10:20 AM, Kimberly D. Walls ((Ingram)) wrote:> Another example: > http://www.netsourcery.com/westerncotton/committees/ > members.html?committeesk > u=3006&committeename=Pima%20Committee > > You can view the members of each committee to see consistency in the > problem. > > > > > > -----Original Message----- > From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf > Of Kimberly D. Walls (Ingram) > Sent: Wednesday, December 11, 2002 11:15 AM > To: WebCatalog Talk > Subject: Re: Showing Results Alphabetically in Columns (top to bottom) > > > This helps tremendously!! Thanks so much. > > The only problem I am having now is in the last row. > > If there are three columns worth of results, the last row shows up just > fine, HOWEVER if there are only 1 or 2 items to display in the last > row... > the table breaks. > > I'm still working on this, but you can see the issue here: > http://www.netsourcery.com/westerncotton/committees/ > members.html?committeesk > u=3008&committeename=Rules%20%26%20By-Laws > > > > Any insight would be great! > > The code: (Thanks to Ron at Inkblot Media) > > > [math show=f]on=0[/math] > [math show=f]stop=3[/math] > > [search > db=/dbases/westerncotton/ > contacts.txt&wscommitteedatarq=[committeesku]&lname > sort=1&lnamesdir=as] > [text]break=[math][numfound]/3[/math][/text] > > > [hideif [stop]=[on]] > > [/hideif] > > [/search] >
> [founditems] > [fname] > [lname]
> [showif [index]\[break]] > [math]on=[on]+1[/math] > 		> [/hideif] > [/showif] > [/founditems] > [hideif [stop]=[on]] >
> > > > > > -----Original Message----- > From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf > Of Inkblot Media > Sent: Tuesday, December 10, 2002 9:37 PM > To: WebCatalog Talk > Subject: Re: Showing Results Alphabetically in Columns (top to bottom) > > > The code I sent earlier will work, but it adds a blank cell to the end > of > the table. The following code removes that and I aded some comments to > help > explain what I am doing. In case you want to edit the code. > > Hope this helps. > > [!] ------------------------------------------- [/!] > [!] On = the table cell we are working on. > Stop = the number of cells you want > We will use these to ensure that we do not > have any trailing cells [/!] > [!] ------------------------------------------- [/!] > > [math show=f]on=0[/math] > [math show=f]stop=3[/math] > > > > > [!] ------------------------------------------- [/!] > [!] Do search as normal as set the SORT to as [/!] > [!] ------------------------------------------- [/!] > > [search db=my.db&neIDdatarq=ALL&asIDsort=1] > > [!] ------------------------------------------- [/!] > [!] Break = where to end a cell and start a new > one. It is the number of found items divided > by the number of cells you want. [/!] > [!] ------------------------------------------- [/!] > > [text]break=[math][numfound]/3[/math][/text] > > > > [!] ------------------------------------------- [/!] > [!] The hideif checks to see if on = stop. > If it does then it hides the cell opening. [/!] > [!] ------------------------------------------- [/!] > > [hideif [stop]=[on]] > > [/hideif] > > > [/search] >
> [founditems] > [id]
> > [!] ------------------------------------------- [/!] > [!] The showif takes the index # of the > founditem and checks to see if it is > divisable by the # of cells you want. If it > is then it closes the cell and starts a new > cell. [/!] > [!] ------------------------------------------- [/!] > > [showif [index]\[break]] > > [!] ------------------------------------------- [/!] > [!] The math adds one to the on variable [/!] > [!] ------------------------------------------- [/!] > > [math]on=[on]+1[/math] > 		> [/hideif] > [/showif] > [/founditems] > > [!] ------------------------------------------- [/!] > [!] The hideif checks to see if on = stop. > If it does then it hides the cell opening. [/!] > [!] ------------------------------------------- [/!] > [hideif [stop]=[on]] >
> ----- Original Message ----- > From: Kimberly D. Walls (Ingram) > To: WebCatalog Talk > Sent: Tuesday, December 10, 2002 5:21 PM > Subject: Showing Results Alphabetically in Columns (top to bottom) > > >> Surely, someone has found a way to make this happen... but I can't >> seem to >> find anything in the archives. Probably because I don't know what to >> look >> for. >> >> >> >> [search >> db=database.txt&wscommitteedatarq=[committeesku]&lnamesort=1&lnamesdir >> =as] >> >> [founditems] >> >> >> >> [fname] [lname] >> >> >> >> [showif [index]\3][/showif] >> >> [/founditems] >> >> [/search] >> >> >> >> This particular line: [showif [index]\3][/showif] >> >> brings back results in three columns... but alphabetically from left >> to >> right across the columns. How would I go about showing results in >> alphabetical order from top to bottom? >> >> So instead of: >> >> A B C >> >> D E F >> >> I would like to have: >> >> A C E >> >> B D F >> >> >> >> I'm stuck. >> >> Kim >> >> >> >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to > >> Web Archive of this list is at: http://webdna.smithmicro.com/ > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ > > > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ > > > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ > > --------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Showing Results Alphabetically in Columns (top to bottom) (Kimberly D. Walls \(Ingram\) 2002)
  2. Re: Showing Results Alphabetically in Columns (top to bottom) (Donovan 2002)
  3. Re: Showing Results Alphabetically in Columns (top to bottom) (WJ Starck 2002)
  4. Re: Showing Results Alphabetically in Columns (top to bottom) (Rob Marquardt 2002)
  5. Re: Showing Results Alphabetically in Columns (top to bottom) (WJ Starck 2002)
  6. Re: Showing Results Alphabetically in Columns (top to bottom) (WJ Starck 2002)
  7. Re: Showing Results Alphabetically in Columns (top to bottom) (Kimberly D. Walls \(Ingram\) 2002)
  8. Re: Showing Results Alphabetically in Columns (top to bottom) (Kimberly D. Walls \(Ingram\) 2002)
  9. Re: Showing Results Alphabetically in Columns (top to bottom) (WJ Starck 2002)
  10. Re: Showing Results Alphabetically in Columns (top to bottom) (Andrew Simpson 2002)
  11. Re: Showing Results Alphabetically in Columns (top to bottom) (Donovan Brooke 2002)
  12. Re: Showing Results Alphabetically in Columns (top to bottom) (WJ Starck 2002)
  13. Re: Showing Results Alphabetically in Columns (top to bottom) (Andrew Simpson 2002)
  14. Re: Showing Results Alphabetically in Columns (top to bottom) (Tim Robinson 2002)
  15. Re: Showing Results Alphabetically in Columns (top to bottom) (Andrew Simpson 2002)
  16. Re: Showing Results Alphabetically in Columns (top to bottom) (Donovan Brooke 2002)
  17. Re: Showing Results Alphabetically in Columns (top to bottom) (Donovan Brooke 2002)
  18. Re: Showing Results Alphabetically in Columns (top to bottom) (Inkblot Media 2002)
  19. Re: Showing Results Alphabetically in Columns (top to bottom) (Donovan Brooke 2002)
  20. Re: Showing Results Alphabetically in Columns (top to bottom) (Inkblot Media 2002)
  21. Re: Showing Results Alphabetically in Columns (top to bottom) (Andrew Simpson 2002)
  22. Re: Showing Results Alphabetically in Columns (top to bottom) (Andrew Simpson 2002)
  23. Re: Showing Results Alphabetically in Columns (top to bottom) (Kimberly D. Walls \(Ingram\) 2002)
  24. Re: Showing Results Alphabetically in Columns (top to bottom) (Andrew Simpson 2002)
  25. Showing Results Alphabetically in Columns (top to bottom) (Kimberly D. Walls \(Ingram\) 2002)
Kimberly-Look at the code I posted late last night.It won't break with an odd number of cells.Here is what I get with 11 records: 1-Abby 4-Dave 7-Gabe 2-Bob 5-Ed 8-Harold 3-Carl 6-Frank 9-Jack 4-Dave 7-GabeHere's the example: http://www.novaderm.com/test/tabletest.tplWill Starck NovaDerm Skincare Science http://www.novaderm.com wjs@novaderm.comLook On Wednesday, December 11, 2002, at 10:20 AM, Kimberly D. Walls ((Ingram)) wrote:> Another example: > http://www.netsourcery.com/westerncotton/committees/ > members.html?committeesk > u=3006&committeename=Pima%20Committee > > You can view the members of each committee to see consistency in the > problem. > > > > > > -----Original Message----- > From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf > Of Kimberly D. Walls (Ingram) > Sent: Wednesday, December 11, 2002 11:15 AM > To: WebCatalog Talk > Subject: Re: Showing Results Alphabetically in Columns (top to bottom) > > > This helps tremendously!! Thanks so much. > > The only problem I am having now is in the last row. > > If there are three columns worth of results, the last row shows up just > fine, HOWEVER if there are only 1 or 2 items to display in the last > row... > the table breaks. > > I'm still working on this, but you can see the issue here: > http://www.netsourcery.com/westerncotton/committees/ > members.html?committeesk > u=3008&committeename=Rules%20%26%20By-Laws > > > > Any insight would be great! > > The code: (Thanks to Ron at Inkblot Media) > > > [math show=f]on=0[/math] > [math show=f]stop=3[/math] > > [search > db=/dbases/westerncotton/ > contacts.txt&wscommitteedatarq=[committeesku]&lname > sort=1&lnamesdir=as] > [text]break=[math][numfound]/3[/math][/text] > > > [hideif [stop]=[on]] > > [/hideif] > > [/search] >
> [founditems] > [fname] > [lname]
> [showif [index]\[break]] > [math]on=[on]+1[/math] > 		> [/hideif] > [/showif] > [/founditems] > [hideif [stop]=[on]] >
> > > > > > -----Original Message----- > From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf > Of Inkblot Media > Sent: Tuesday, December 10, 2002 9:37 PM > To: WebCatalog Talk > Subject: Re: Showing Results Alphabetically in Columns (top to bottom) > > > The code I sent earlier will work, but it adds a blank cell to the end > of > the table. The following code removes that and I aded some comments to > help > explain what I am doing. In case you want to edit the code. > > Hope this helps. > > [!] ------------------------------------------- [/!] > [!] On = the table cell we are working on. > Stop = the number of cells you want > We will use these to ensure that we do not > have any trailing cells [/!] > [!] ------------------------------------------- [/!] > > [math show=f]on=0[/math] > [math show=f]stop=3[/math] > > > > > [!] ------------------------------------------- [/!] > [!] Do search as normal as set the SORT to as [/!] > [!] ------------------------------------------- [/!] > > [search db=my.db&neIDdatarq=ALL&asIDsort=1] > > [!] ------------------------------------------- [/!] > [!] Break = where to end a cell and start a new > one. It is the number of found items divided > by the number of cells you want. [/!] > [!] ------------------------------------------- [/!] > > [text]break=[math][numfound]/3[/math][/text] > > > > [!] ------------------------------------------- [/!] > [!] The hideif checks to see if on = stop. > If it does then it hides the cell opening. [/!] > [!] ------------------------------------------- [/!] > > [hideif [stop]=[on]] > > [/hideif] > > > [/search] >
> [founditems] > [id]
> > [!] ------------------------------------------- [/!] > [!] The showif takes the index # of the > founditem and checks to see if it is > divisable by the # of cells you want. If it > is then it closes the cell and starts a new > cell. [/!] > [!] ------------------------------------------- [/!] > > [showif [index]\[break]] > > [!] ------------------------------------------- [/!] > [!] The math adds one to the on variable [/!] > [!] ------------------------------------------- [/!] > > [math]on=[on]+1[/math] > 		> [/hideif] > [/showif] > [/founditems] > > [!] ------------------------------------------- [/!] > [!] The hideif checks to see if on = stop. > If it does then it hides the cell opening. [/!] > [!] ------------------------------------------- [/!] > [hideif [stop]=[on]] >
> ----- Original Message ----- > From: Kimberly D. Walls (Ingram) > To: WebCatalog Talk > Sent: Tuesday, December 10, 2002 5:21 PM > Subject: Showing Results Alphabetically in Columns (top to bottom) > > >> Surely, someone has found a way to make this happen... but I can't >> seem to >> find anything in the archives. Probably because I don't know what to >> look >> for. >> >> >> >> [search >> db=database.txt&wscommitteedatarq=[committeesku]&lnamesort=1&lnamesdir >> =as] >> >> [founditems] >> >> >> >> [fname] [lname] >> >> >> >> [showif [index]\3][/showif] >> >> [/founditems] >> >> [/search] >> >> >> >> This particular line: [showif [index]\3][/showif] >> >> brings back results in three columns... but alphabetically from left >> to >> right across the columns. How would I go about showing results in >> alphabetical order from top to bottom? >> >> So instead of: >> >> A B C >> >> D E F >> >> I would like to have: >> >> A C E >> >> B D F >> >> >> >> I'm stuck. >> >> Kim >> >> >> >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to > >> Web Archive of this list is at: http://webdna.smithmicro.com/ > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ > > > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ > > > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ > > --------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ WJ Starck

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:

Needed, Freelance Web Developer (2007) WebCat2b15MacPlugIn - [authenticate] not [protect] (1997) Country & Ship-to address & other fields ? (1997) More on the email templates (1997) Ampersands in database fields? (1998) [WebDNA] WebDNA Code and HTML WYSIWYG Editors (2011) OT: Verbose messages - Web*4.2 (2000) Revisit: speed test (2002) PIXO (1997) Practice runs ? (1997) latest version? (1998) RE: type 2 errors with ssl server (1997) New WebDNA Forum Solution (in development) (2003) Multiple prices (1997) Problems with [Applescript] (1997) Silly Question (1997) formatting dates from a field ... (1997) why won't this work, please tell me??? (2001) Supressing Error Messages (1998) suffix mapping, use of cache, etc. (1997)