Re: Unique Sort
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 48457
interpreted = N
texte = stephen 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 Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4501 Forbes Boulevard Suite H Lanham, MD 20706 301-459-3366 x.5010 fax 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/
Associated Messages, from the most recent to the oldest:
stephen 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 Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4501 Forbes Boulevard Suite H Lanham, MD 20706 301-459-3366 x.5010 fax 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/
John Peacock
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:
[ot] New List. Was: Webcat no longer supported? (2006)
Max Record length restated as maybe bug (1997)
WebCatalog/Mac 2.1b2 New Features (1997)
Missing Cart Information (2003)
Re:How to Display text in empty fields (1997)
ShowNext (1997)
Re:Subject: Mail Server Software (1998)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Web Cat and MS SQL 6.5 (1999)
Bill To - Ship To Information display (1997)
form data submission gets truncated (1997)
PSC recommends what date format yr 2000??? (1997)
Signal Raised Error (Part II) (1997)
HELP WITH DATES (1997)
Signal Raised (1997)
WCS Newbie question (1997)
Umm...about those log files? (Off Topic) (1997)
HELP WITH DATES (1997)
Banners (1997)
Math (1997)