Re: [WebDNA] Quick sort/results grouping Q

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 101366
interpreted = N
texte = --Apple-Mail-2-804747924 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Try something like this: [search table=LONGRANGE&neJ_UNITdatarq=[blank]&J_UNITsort=1&J_UNITsumm=T] [founditems] [J_UNIT] in [IN_AREA] has:
[search table=LONGRANGE&neJ_UNITdatarq=[J_UNIT]&asT_AREAsort=1] [founditems] [T_AREA] in range.
[/founditems][/search] [/founditems][/search] On Nov 7, 2008, at 12:03 AM, 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/ --Apple-Mail-2-804747924 Content-Disposition: attachment; filename=smime.p7s Content-Type: application/pkcs7-signature; name=smime.p7s Content-Transfer-Encoding: base64 MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGGTCCAtIw ggI7oAMCAQICEBmvvAg5L6PclE8ruwo/gMYwDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UEBhMCWkEx JTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQ ZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA4MDkyNzAxMTg1M1oXDTA5MDkyNzAxMTg1 M1owPjEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEbMBkGCSqGSIb3DQEJARYMcG1A d2ViZG5hLnVzMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAtb7ZYYJV7sbgqxdgpBU/ qCRsIJYGNIo40L9odKmo6Y/mPBybeSry8KefqmuWoBXxc6xCvSSJDWFcb2sZ+TkedZrdxvtoL1pH NjDZNe2ow+RCNUvJcQd1+ASzh0J4QLHnNyoMY3zuCQwqM6hK5gU4AlpOSITekksSFuGXBdJTjSeI gIpZFTTrd1c/Zv7miT9gO5UmHiyDClKP8oX31YFlb3q9EM2p8WQzb2Ce2M9kokCs8ZnhT+fRNc/Q 9lc4RJtEuf3zynvg0cCbf71pgoC0Zepsop466jrvc08MsxxzRJDmjw20ci/3ltk+iAcD3TchYppw yX4HZhjrrZXcOMBMkQIDAQABoykwJzAXBgNVHREEEDAOgQxwbUB3ZWJkbmEudXMwDAYDVR0TAQH/ BAIwADANBgkqhkiG9w0BAQUFAAOBgQCBMxqOGsLwOxtLQ8YLvOQOym8UQyB0CiF0Dpd0oOA+hjD5 n9A1eileTd8OdkdPIb+der2Kw42N/UKARNSSkmn1hhKrgwTNYLyXFNlB+TJ2YvG13B27d4EaUdSn 2KWKDKG4w14lQSO9y+RTjMSuYi4kbeI50QHLZsTZDO3OhNcKjzCCAz8wggKooAMCAQICAQ0wDQYJ KoZIhvcNAQEFBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNV BAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRp ZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBGcmVl bWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1haWxAdGhhd3RlLmNvbTAeFw0w MzA3MTcwMDAwMDBaFw0xMzA3MTYyMzU5NTlaMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3 dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1h aWwgSXNzdWluZyBDQTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAxKY8VXNV+065yplaHmjA dQRwnd/p/6Me7L3N9VvyGna9fww6YfK/Uc4B1OVQCjDXAmNaLIkVcI7dyfArhVqqP3FWy688Cwfn 8R+RNiQqE88r1fOCdz0Dviv+uxg+B79AgAJk16emu59l0cUqVIUPSAR/p7bRPGEEQB5kGXJgt/sC AwEAAaOBlDCBkTASBgNVHRMBAf8ECDAGAQH/AgEAMEMGA1UdHwQ8MDowOKA2oDSGMmh0dHA6Ly9j cmwudGhhd3RlLmNvbS9UaGF3dGVQZXJzb25hbEZyZWVtYWlsQ0EuY3JsMAsGA1UdDwQEAwIBBjAp BgNVHREEIjAgpB4wHDEaMBgGA1UEAxMRUHJpdmF0ZUxhYmVsMi0xMzgwDQYJKoZIhvcNAQEFBQAD gYEASIzRUIPqCy7MDaNmrGcPf6+svsIXoUOWlJ1/TCG4+DYfqi2fNi/A9BxQIJNwPP2t4WFiw9k6 GX6EsZkbAMUaC4J0niVQlGLH2ydxVyWN3amcOY6MIE9lX5Xa9/eH1sYITq726jTlEBpbNU1341Yh eILcIRk13iSx0x1G/11fZU8xggMQMIIDDAIBATB2MGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxU aGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJl ZW1haWwgSXNzdWluZyBDQQIQGa+8CDkvo9yUTyu7Cj+AxjAJBgUrDgMCGgUAoIIBbzAYBgkqhkiG 9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wODExMDcxNTQyNDdaMCMGCSqGSIb3 DQEJBDEWBBRDVuqEBpd5Mk130mZpIucggIsxPzCBhQYJKwYBBAGCNxAEMXgwdjBiMQswCQYDVQQG EwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhh d3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEBmvvAg5L6PclE8ruwo/gMYwgYcGCyqG SIb3DQEJEAILMXigdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcg KFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EC EBmvvAg5L6PclE8ruwo/gMYwDQYJKoZIhvcNAQEBBQAEggEAKZJ+PUFF3rjm2ROsbF9jyI4zyee3 l/ad8BLm4MHP8eXPMTD2q3FBG5vKkT8zRfZbYlOl9VrHqLHBBjkgkrcdPH04uDC1qJYWougJIouh a+VH4lvvlMSoZu85Cj8l1VU7OTylKVkh2n6cJIHFEvixETgSyHsOXhrnsYoXe+xLfObRByzUj07c QRqXpkVWXDVkI3/VST728YUTLAUKadKcYNTqxl63CIwVMdPypgC8v1hYechovUMWH3CXds8cBF2X q7ifutgTRteTtKyngZZP/uTMBLIh+FhsyBhUO7RAWmVlhGgHoYPswA4bu+WoQisc2vJLmd55ECC6 o+eG8SxOIwAAAAAAAA== --Apple-Mail-2-804747924-- 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)
--Apple-Mail-2-804747924 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Try something like this: [search table=LONGRANGE&neJ_UNITdatarq=[blank]&J_UNITsort=1&J_UNITsumm=T] [founditems] [J_UNIT] in [IN_AREA] has:
[search table=LONGRANGE&neJ_UNITdatarq=[J_UNIT]&asT_AREAsort=1] [founditems] [T_AREA] in range.
[/founditems][/search] [/founditems][/search] On Nov 7, 2008, at 12:03 AM, 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/ --Apple-Mail-2-804747924 Content-Disposition: attachment; filename=smime.p7s Content-Type: application/pkcs7-signature; name=smime.p7s Content-Transfer-Encoding: base64 MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGGTCCAtIw ggI7oAMCAQICEBmvvAg5L6PclE8ruwo/gMYwDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UEBhMCWkEx JTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQ ZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA4MDkyNzAxMTg1M1oXDTA5MDkyNzAxMTg1 M1owPjEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEbMBkGCSqGSIb3DQEJARYMcG1A d2ViZG5hLnVzMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAtb7ZYYJV7sbgqxdgpBU/ qCRsIJYGNIo40L9odKmo6Y/mPBybeSry8KefqmuWoBXxc6xCvSSJDWFcb2sZ+TkedZrdxvtoL1pH NjDZNe2ow+RCNUvJcQd1+ASzh0J4QLHnNyoMY3zuCQwqM6hK5gU4AlpOSITekksSFuGXBdJTjSeI gIpZFTTrd1c/Zv7miT9gO5UmHiyDClKP8oX31YFlb3q9EM2p8WQzb2Ce2M9kokCs8ZnhT+fRNc/Q 9lc4RJtEuf3zynvg0cCbf71pgoC0Zepsop466jrvc08MsxxzRJDmjw20ci/3ltk+iAcD3TchYppw yX4HZhjrrZXcOMBMkQIDAQABoykwJzAXBgNVHREEEDAOgQxwbUB3ZWJkbmEudXMwDAYDVR0TAQH/ BAIwADANBgkqhkiG9w0BAQUFAAOBgQCBMxqOGsLwOxtLQ8YLvOQOym8UQyB0CiF0Dpd0oOA+hjD5 n9A1eileTd8OdkdPIb+der2Kw42N/UKARNSSkmn1hhKrgwTNYLyXFNlB+TJ2YvG13B27d4EaUdSn 2KWKDKG4w14lQSO9y+RTjMSuYi4kbeI50QHLZsTZDO3OhNcKjzCCAz8wggKooAMCAQICAQ0wDQYJ KoZIhvcNAQEFBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNV BAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRp ZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBGcmVl bWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1haWxAdGhhd3RlLmNvbTAeFw0w MzA3MTcwMDAwMDBaFw0xMzA3MTYyMzU5NTlaMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3 dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1h aWwgSXNzdWluZyBDQTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAxKY8VXNV+065yplaHmjA dQRwnd/p/6Me7L3N9VvyGna9fww6YfK/Uc4B1OVQCjDXAmNaLIkVcI7dyfArhVqqP3FWy688Cwfn 8R+RNiQqE88r1fOCdz0Dviv+uxg+B79AgAJk16emu59l0cUqVIUPSAR/p7bRPGEEQB5kGXJgt/sC AwEAAaOBlDCBkTASBgNVHRMBAf8ECDAGAQH/AgEAMEMGA1UdHwQ8MDowOKA2oDSGMmh0dHA6Ly9j cmwudGhhd3RlLmNvbS9UaGF3dGVQZXJzb25hbEZyZWVtYWlsQ0EuY3JsMAsGA1UdDwQEAwIBBjAp BgNVHREEIjAgpB4wHDEaMBgGA1UEAxMRUHJpdmF0ZUxhYmVsMi0xMzgwDQYJKoZIhvcNAQEFBQAD gYEASIzRUIPqCy7MDaNmrGcPf6+svsIXoUOWlJ1/TCG4+DYfqi2fNi/A9BxQIJNwPP2t4WFiw9k6 GX6EsZkbAMUaC4J0niVQlGLH2ydxVyWN3amcOY6MIE9lX5Xa9/eH1sYITq726jTlEBpbNU1341Yh eILcIRk13iSx0x1G/11fZU8xggMQMIIDDAIBATB2MGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxU aGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJl ZW1haWwgSXNzdWluZyBDQQIQGa+8CDkvo9yUTyu7Cj+AxjAJBgUrDgMCGgUAoIIBbzAYBgkqhkiG 9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wODExMDcxNTQyNDdaMCMGCSqGSIb3 DQEJBDEWBBRDVuqEBpd5Mk130mZpIucggIsxPzCBhQYJKwYBBAGCNxAEMXgwdjBiMQswCQYDVQQG EwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhh d3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEBmvvAg5L6PclE8ruwo/gMYwgYcGCyqG SIb3DQEJEAILMXigdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcg KFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EC EBmvvAg5L6PclE8ruwo/gMYwDQYJKoZIhvcNAQEBBQAEggEAKZJ+PUFF3rjm2ROsbF9jyI4zyee3 l/ad8BLm4MHP8eXPMTD2q3FBG5vKkT8zRfZbYlOl9VrHqLHBBjkgkrcdPH04uDC1qJYWougJIouh a+VH4lvvlMSoZu85Cj8l1VU7OTylKVkh2n6cJIHFEvixETgSyHsOXhrnsYoXe+xLfObRByzUj07c QRqXpkVWXDVkI3/VST728YUTLAUKadKcYNTqxl63CIwVMdPypgC8v1hYechovUMWH3CXds8cBF2X q7ifutgTRteTtKyngZZP/uTMBLIh+FhsyBhUO7RAWmVlhGgHoYPswA4bu+WoQisc2vJLmd55ECC6 o+eG8SxOIwAAAAAAAA== --Apple-Mail-2-804747924-- Patrick McCormick

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:

Bug or syntax error on my part? (1997) hmmm (2006) Refresh cart# (1999) Re1000001: Setting up shop (1997) Stopping bad HTML propagation ? (1997) linetiems in thankyou.tpl (1997) virtual domain service (1997) Help! WebCat2 bug (1997) Can anyone help me with this shipping thing? (1998) lineitem variables (1999) Return records from another (1997) What am I missing (1997) Updating product information (2002) Re:quit command on NT (1997) a * question (2003) can webcat create directories on NT? (1997) How to verify email address (1997) Search all Fields in a db (1997) Discounts (2001) Mac 2.1b4 unknown error: BadSuffix (1997)