Re: Unique Sort
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 48460
interpreted = N
texte = I want to list all the 3M... under the 3, but only have one 3 and so on.-----Original Message-----From: stephen Sent: Thursday, March 06, 2003 11:07 AMTo: WebDNA TalkSubject: Re: Unique SortIt kind of works, but it is repeating, I get this:3 3M - OFFICE & STATIONARY DIVISION 3M - OFFICE & STATIONARY DIVISION 3 3M VISUAL SYSTEMS DIVISION 3M VISUAL SYSTEMS DIVISION A APRICORN MASS STORAGE APRICORN MASS STORAGE B BELKIN COMPONENTS BELKIN COMPONENTS B BROTHER INT L (SUPPLIES) BROTHER INT L (SUPPLIES) -----Original Message-----From: John Peacock [mailto:jpeacock@rowman.com]Sent: Thursday, March 06, 2003 11:15 AMTo: WebDNA TalkSubject: Re: Unique Sortstephen wrote:> How can sort my results in the following format:> > 3> 3M > 3M Visual Systems Division > > A> Acer Latin America > Apricorn Mass Storage > > B> Belkin Components > Brother Int'l (printers) > No tested code, just ideas...First, do a summary sort on whatever field you are talking about. Next, create a text variable for the header and set it to blank. Then, in the [founditems] loop, grab the first character of the next record and see if it is the same as the existing header value; if not, set the header value to be that new character and do whatever formatting you want to seperate the sections.Sort of like this:[search db=blah&so-on] [text]heading=[/text] [founditems] [if [heading]![getchars start=1&end=1][yourfield][/getchars]] [text]heading=[getchars start=1&end=1][yourfield][/getchars][/text]
[heading] [/if] [yourfield] [/founditems][/search]HTHJohn-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4501 Forbes BoulevardSuite HLanham, MD 20706301-459-3366 x.5010fax 301-429-5748-------------------------------------------------------------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:
I want to list all the 3M... under the 3, but only have one 3 and so on.-----Original Message-----From: stephen Sent: Thursday, March 06, 2003 11:07 AMTo: WebDNA TalkSubject: Re: Unique SortIt kind of works, but it is repeating, I get this:3 3M - OFFICE & STATIONARY DIVISION 3M - OFFICE & STATIONARY DIVISION 3 3M VISUAL SYSTEMS DIVISION 3M VISUAL SYSTEMS DIVISION A APRICORN MASS STORAGE APRICORN MASS STORAGE B BELKIN COMPONENTS BELKIN COMPONENTS B BROTHER INT L (SUPPLIES) BROTHER INT L (SUPPLIES) -----Original Message-----From: John Peacock [mailto:jpeacock@rowman.com]Sent: Thursday, March 06, 2003 11:15 AMTo: WebDNA TalkSubject: Re: Unique Sortstephen wrote:> How can sort my results in the following format:> > 3> 3M > 3M Visual Systems Division > > A> Acer Latin America > Apricorn Mass Storage > > B> Belkin Components > Brother Int'l (printers) > No tested code, just ideas...First, do a summary sort on whatever field you are talking about. Next, create a text variable for the header and set it to blank. Then, in the [founditems] loop, grab the first character of the next record and see if it is the same as the existing header value; if not, set the header value to be that new character and do whatever formatting you want to seperate the sections.Sort of like this:[search db=blah&so-on] [text]heading=[/text] [founditems] [if [heading]![getchars start=1&end=1][yourfield][/getchars]] [text]heading=[getchars start=1&end=1][yourfield][/getchars][/text]
[heading] [/if] [yourfield] [/founditems][/search]HTHJohn-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4501 Forbes BoulevardSuite HLanham, MD 20706301-459-3366 x.5010fax 301-429-5748-------------------------------------------------------------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/
stephen
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:
WebCat2 - [format thousands] (1997)
Exclude by date - multiple (1997)
Protect (1997)
Need relative path explanation (1997)
New Guestbook Source (1997)
WHY SO MANY DUPLICATES? (1999)
credit card - Revised (1997)
Use of Back and Reload Buttons on ShoppingCart page? (1997)
NewCart+Search with one click ? (1997)
Dubble Sku's in a Database (1999)
Database Options (1997)
Understanding texta (1997)
[protect] on NT? (1997)
Banner DNA (1997)
sort problems....bug or brain fart? (1997)
[ConvertChars] problem (1997)
Quit revisited (1997)
FTP FOLDER PERMISSIONS (2004)
suggestion (1997)
instant cookies? (1999)