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

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 46188
interpreted = N
texte = 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/ 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)
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/ Inkblot Media

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:

Format all of a sudden doesn't work (1997) Can this be done? (1997) Monthly Reports (2000) answers - opinions? (1998) [WebDNA] Range calculation w/negative values (2011) WebCatalog and WebMerchant reviewed by InfoWorld (1997) Re:quit command on NT (1997) self maintaining databases? (1998) Emailer setup (1997) multiple search commands (1997) OLD PROBLEM (1997) webCatalog and Stocks (1998) Associative lookup style? + bit more (1997) Newbie problem blah blah blah (1997) Building Calendars (1997) Upgrading old WebCat Database Files (1997) [SearchString] usage (1997) [INCLUDE] Limitations (1998) Generating unique SKU from [cart] - Still Stumped... (1997) Snake Bites (1997)