Re: Showing Results Alphabetically in Columns (top to bottom)
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 46224
interpreted = N
texte = Bah!Looks like I spoke too soon.Let me have a look see...-Will;On Wednesday, December 11, 2002, at 10:30 AM, WJ Starck wrote:> 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-Gabe > > Here's the example: http://www.novaderm.com/test/tabletest.tpl > > Will Starck > NovaDerm Skincare Science > http://www.novaderm.com > wjs@novaderm.com > > > > Look > 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] >> >> >> [founditems] >> [fname] >> [lname]
>> [showif [index]\[break]] >> [math]on=[on]+1[/math] >> | >> [hideif [stop]=[on]] >> >> [/hideif] >> [/showif] >> [/founditems] >> [hideif [stop]=[on]] >> | >> [/hideif] >>
>> [/search] >>
>> >> >> >> >> >> -----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] >> >> >> >> [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] >> | >> [!] ------------------------------------------- [/!] >> [!] The hideif checks to see if on = stop. >> If it does then it hides the cell opening. [/!] >> [!] ------------------------------------------- [/!] >> >> [hideif [stop]=[on]] >> >> [/hideif] >> [/showif] >> [/founditems] >> >> [!] ------------------------------------------- [/!] >> [!] The hideif checks to see if on = stop. >> If it does then it hides the cell opening. [/!] >> [!] ------------------------------------------- [/!] >> [hideif [stop]=[on]] >> | >> [/hideif] >>
>> >> [/search] >>
>> ----- 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&lnamesdi >>> r=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/ > ------------------------------------------------------------- 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:
Bah!Looks like I spoke too soon.Let me have a look see...-Will;On Wednesday, December 11, 2002, at 10:30 AM, WJ Starck wrote:> 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-Gabe > > Here's the example: http://www.novaderm.com/test/tabletest.tpl > > Will Starck > NovaDerm Skincare Science > http://www.novaderm.com > wjs@novaderm.com > > > > Look > 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] >> >> >> [founditems] >> [fname] >> [lname]
>> [showif [index]\[break]] >> [math]on=[on]+1[/math] >> | >> [hideif [stop]=[on]] >> >> [/hideif] >> [/showif] >> [/founditems] >> [hideif [stop]=[on]] >> | >> [/hideif] >>
>> [/search] >>
>> >> >> >> >> >> -----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] >> >> >> >> [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] >> | >> [!] ------------------------------------------- [/!] >> [!] The hideif checks to see if on = stop. >> If it does then it hides the cell opening. [/!] >> [!] ------------------------------------------- [/!] >> >> [hideif [stop]=[on]] >> >> [/hideif] >> [/showif] >> [/founditems] >> >> [!] ------------------------------------------- [/!] >> [!] The hideif checks to see if on = stop. >> If it does then it hides the cell opening. [/!] >> [!] ------------------------------------------- [/!] >> [hideif [stop]=[on]] >> | >> [/hideif] >>
>> >> [/search] >>
>> ----- 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&lnamesdi >>> r=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/ > ------------------------------------------------------------- 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:
Order not created error (1997)
WebCat2 - [format thousands] (1997)
Unceremonious Unwanted Unsubscription (1999)
America Online Issues (1998)
Date Help! (2003)
WebCatalog Technical Reference (1997)
Protecting Images (2003)
[WebDNA] Good advise on [Showif] or alternative... (2012)
[ShowIf] a either fields are blank (1998)
Maybe minor bug report (1997)
username's and passwords in uppercase vs lowercase vs mix. (2000)
RE: WebCat and image maps (1997)
Random again (2003)
Security Question (1997)
Some Advise needed (1997)
Appending space (1998)
Running 2 two WebCatalog.acgi's (1996)
textarea question (1998)
Not really WebCat (1997)
[WebDNA] trigger won't follow path? maybe (2009)