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:
WC1.6 to WC2 date formatting (1997)
SKU (1997)
[WebDNA] macOS High Sierra (2017)
[WebDNA] Issue with some clouds (2009)
[isfile] ? (1997)
Pull Down Search (2000)
Listfiles and nothing found (2001)
Undeclared variables (2004)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
[WebDNA] Triggers not working (2011)
OT : Site speed feedback (2002)
Multi Math bug? (2000)
range searching (1998)
encryption in browser? (1998)
Server Freeze (1998)
Weird problems with [SHOWIF]s (1997)
Re[2]: 2nd WebCatalog2 Feature Request (1996)
WebCat2: Items xx to xx shown, etc. (1997)
OT. Self explanatory (2003)
Protect vs Authenicate (1997)