Re: [WebDNA] Quick sort/results grouping Q

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 101364
interpreted = N
texte = --=====================_786181203==.ALT Content-Type: text/plain; charset="us-ascii" Nevermind, was easy enough: [search table=LONGRANGE&neJ_UNITdatarq=[blank]&max=1] [founditems] [search table=LONGRANGE&eqT_AREAdatarq=[T_AREA]] [showif [numfound]>0] [founditems] [J_UNIT] in [IN_AREA] has [T_AREA] in range.
[/founditems] [/showif] [/search] [/founditems] [/search] At 12:03 AM 11/7/2008, you 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 --=====================_786181203==.ALT Content-Type: text/html; charset="us-ascii" Nevermind, was easy enough:

[search table=LONGRANGE&neJ_UNITdatarq=[blank]&max=1]
[founditems]
        [search table=LONGRANGE&eqT_AREAdatarq=[T_AREA]]
        [showif [numfound]>0]
         [founditems]
[J_UNIT] in [IN_AREA] has [T_AREA] in range.<br>
         [/founditems]
         [/showif]
         [/search]
[/founditems]
[/search]

At 12:03 AM 11/7/2008, you 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.<br>
[/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
--=====================_786181203==.ALT-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Quick sort/results grouping Q (Patrick McCormick 2008)
  2. Re: [WebDNA] Quick sort/results grouping Q (Gary Krockover 2008)
  3. Re: [WebDNA] Quick sort/results grouping Q (Patrick McCormick 2008)
  4. Re: [WebDNA] Quick sort/results grouping Q (Patrick McCormick 2008)
  5. Re: [WebDNA] Quick sort/results grouping Q (Patrick McCormick 2008)
  6. Re: [WebDNA] Quick sort/results grouping Q (Kenneth Grome 2008)
  7. Re: [WebDNA] Quick sort/results grouping Q (Gary Krockover 2008)
  8. Re: [WebDNA] Quick sort/results grouping Q (Stuart Tremain 2008)
  9. [WebDNA] Quick sort/results grouping Q (Gary Krockover 2008)
--=====================_786181203==.ALT Content-Type: text/plain; charset="us-ascii" Nevermind, was easy enough: [search table=LONGRANGE&neJ_UNITdatarq=[blank]&max=1] [founditems] [search table=LONGRANGE&eqT_AREAdatarq=[T_AREA]] [showif [numfound]>0] [founditems] [J_UNIT] in [IN_AREA] has [T_AREA] in range.
[/founditems] [/showif] [/search] [/founditems] [/search] At 12:03 AM 11/7/2008, you 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 --=====================_786181203==.ALT Content-Type: text/html; charset="us-ascii" Nevermind, was easy enough:

[search table=LONGRANGE&neJ_UNITdatarq=[blank]&max=1]
[founditems]
        [search table=LONGRANGE&eqT_AREAdatarq=[T_AREA]]
        [showif [numfound]>0]
         [founditems]
[J_UNIT] in [IN_AREA] has [T_AREA] in range.<br>
         [/founditems]
         [/showif]
         [/search]
[/founditems]
[/search]

At 12:03 AM 11/7/2008, you 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.<br>
[/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
--=====================_786181203==.ALT-- Gary Krockover

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:

Another bug to squash (WebCat2b13 Mac .acgi) (1997) Subtotal Not Calculated on Invoice.html (1998) Bug or syntax error on my part? (1997) WebTen? (1997) Limit on nested [ShowIf]'s? (1997) Where's Cart Created ? (1997) encryption in browser? (1998) Multi-processor Mac info ... (1997) Dumb Question about Docs (1997) shell question (2004) Calendar using WebCatalog? (1997) Re[2]: 2nd WebCatalog2 Feature Request (1996) ShipCosts database (1997) A question on sub-categories (1997) Fun with Dates - revisited (1997) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) History of beta changes? (1999) Parameter Passing (2000) Wierd problem with 3.08 WIN Version (2000) Keep away (1997)