Re: [WebDNA] Quick sort/results grouping Q
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 101363
interpreted = N
texte = Gary With your sort asT_AREAsort=1 you should get this: > 109-3 ART in Chidori Airfield has Double Root Beach in range. > 109-2 ART in Funami Dai has Warbler Village in range. > 109-3 ART in Chidori Airfield has Warbler Village in range. > 109-2 ART in Funami Dai has Western Village in range. > 109-3 ART in Chidori Airfield has Western Coast in range. I am a little confused as to what you want, please give us a text example Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 07/11/2008, at 5:03 PM, Gary Krockover wrote: > If I have this query: > > [search table=LONGRANGE&neJ_UNITdatarq=[blank]&asT_AREAsort=1] > [founditems] > [J_UNIT] in [IN_AREA] has [T_AREA] in range.
> [/founditems] > [/search] > > That produces this result: > > 109-2 ART in Funami Dai has Western Village in range. > 109-2 ART in Funami Dai has Warbler Village in range. > 109-3 ART in Chidori Airfield has Warbler Village in range. > 109-3 ART in Chidori Airfield has Double Root Beach in range. > 109-3 ART in Chidori Airfield has Western Coast in range. > > How can I group it so that [J_UNIT] (ex: 109-2 ART) appears only > once and has the same T_AREA (ex: Funami Dai) as another T_UNIT? > > Optimal results would be: > > 109-2 ART in Funami Dai has Warbler Village in range. > 109-3 ART in Chidori Airfield has Warbler Village in range. > > Possible without several nested searches possibly? > > GJK > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list
. > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/
Associated Messages, from the most recent to the oldest:
Gary With your sort asT_AREAsort=1 you should get this: > 109-3 ART in Chidori Airfield has Double Root Beach in range. > 109-2 ART in Funami Dai has Warbler Village in range. > 109-3 ART in Chidori Airfield has Warbler Village in range. > 109-2 ART in Funami Dai has Western Village in range. > 109-3 ART in Chidori Airfield has Western Coast in range. I am a little confused as to what you want, please give us a text example Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 07/11/2008, at 5:03 PM, Gary Krockover wrote: > If I have this query: > > [search table=LONGRANGE&neJ_UNITdatarq=[blank]&asT_AREAsort=1] > [founditems] > [J_UNIT] in [IN_AREA] has [T_AREA] in range.
> [/founditems] > [/search] > > That produces this result: > > 109-2 ART in Funami Dai has Western Village in range. > 109-2 ART in Funami Dai has Warbler Village in range. > 109-3 ART in Chidori Airfield has Warbler Village in range. > 109-3 ART in Chidori Airfield has Double Root Beach in range. > 109-3 ART in Chidori Airfield has Western Coast in range. > > How can I group it so that [J_UNIT] (ex: 109-2 ART) appears only > once and has the same T_AREA (ex: Funami Dai) as another T_UNIT? > > Optimal results would be: > > 109-2 ART in Funami Dai has Warbler Village in range. > 109-3 ART in Chidori Airfield has Warbler Village in range. > > Possible without several nested searches possibly? > > GJK > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/
Stuart Tremain
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:
WebCat2b12 - nesting [tags] (1997)
BBEdit and WebCatalog 2.0? (1997)
database size? (1997)
Simple Store (2000)
Shopping cart not being assigned (1999)
Press Release hit the NewsWire!!! (1997)
Training Announcement (2004)
Number of Feilds Passed to [append] (2000)
Online reference (1997)
Variables for chat (1997)
WebCat (or other) Indexing (1999)
WebCommerce: Folder organization ? (1997)
[/application] error? (1997)
emailer settings and control questions (1997)
WC1.6 to WC2 date formatting (1997)
[shownext max=?] armed (1997)
Duplicates (1998)
[WebDNA] Calendar Edit (2010)
RE: WebCat and image maps (1997)
What the *(**&^* webcat/mer (1998)