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==.ALTContent-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==.ALTContent-Type: text/html; charset="us-ascii"
Nevermind, was easy enough:
[search table=LONGRANGE&neJ_UNITdatarq=[blank]&max=1]
[founditems]
[searchtable=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:
[searchtable=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 andhas 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:
--=====================_786181203==.ALTContent-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==.ALTContent-Type: text/html; charset="us-ascii"
Nevermind, was easy enough:
[search table=LONGRANGE&neJ_UNITdatarq=[blank]&max=1]
[founditems]
[searchtable=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:
[searchtable=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 andhas 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)