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:
2 databases (1997)
[exclusivelock] (was:several people...) (2001)
free "Image Viewer" widget (2004)
$Quit, $CloseDatabase corrections (1997)
suffix mapping for NT? (1997)
Empty Shopping Carts? (1998)
unix permissions theory applied to db security? Or...? (2000)
using showpage and showcart commands (1996)
Banners and sort of random display (1997)
European dates (1998)
Mac: LModelDirector bug fix (1997)
RE: Cart Template (1997)
ErrorMessages.db suggestion (1997)
[WebDNA] Windows Installation (2019)
using showpage and showcart commands (1996)
WebCat2final1 crashes (1997)
All choices on IE different than Netscape (1997)
Nested search (1997)
WebCatalog Hosting (1998)
Calculate UnitShipCost in Formulas.db (1999)