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

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 46220
interpreted = N
texte = 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-LawsAny 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/ 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)
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-LawsAny 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/ Kimberly D. Walls \(Ingram\)

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:

webcat NT with [dos] command (1997) RE: Signal Raised (1997) how do ye do this?????? (2001) WCS Newbie question (1997) [WebDNA] Email time bug? (2011) [OT] sbox error (2003) AJAX with WebDNA (2006) Applescript, WebDNA, and PDF (1997) 2nd try:Webcat interfering with Webstar? (1998) Graphing Modules (2004) [WebDNA] TLS 1.2 and [tcpconnect] (2018) SMTP Mail Server (2003) default value from Lookup (was Grant, please help me) (1997) [OT] 'Email this story to a friend' (2003) [WriteFile] problems (1997) docs for WebCatalog2 (1997) Unexpected error (1997) WebCat Mac OS X and Encrypt Help Need (2000) [ot] Any One Want A WebDNA Billing Program? (2003) WebCat2: Items xx to xx shown, etc. (1997)