Re: [WebDNA] Quick sort/results grouping Q

This WebDNA talk-list message is from

2008


It keeps the original formatting.
numero = 101367
interpreted = N
texte = --Apple-Mail-3-804846305 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Ooops: search table=LONGRANGE&neJ_UNITdatarq=[blank]&J_UNITsort=1&J_UNITsumm=T] [founditems] [J_UNIT] in [IN_AREA] has:
[search table=LONGRANGE&eqJ_UNITdatarq=[J_UNIT]&asT_AREAsort=1] [founditems] [T_AREA] in range.
[/founditems][/search] [/founditems][/search] On Nov 7, 2008, at 9:42 AM, Patrick McCormick wrote: > 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-3-804846305 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 9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wODExMDcxNTQ0MjZaMCMGCSqGSIb3 DQEJBDEWBBRRE1Ms8iF5/hWr2D0V/vyRT/vL0zCBhQYJKwYBBAGCNxAEMXgwdjBiMQswCQYDVQQG EwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhh d3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEBmvvAg5L6PclE8ruwo/gMYwgYcGCyqG SIb3DQEJEAILMXigdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcg KFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EC EBmvvAg5L6PclE8ruwo/gMYwDQYJKoZIhvcNAQEBBQAEggEAsxEYES1O4VU1ZVRqny3OGUOAIQtk M/uhTGnJhZHo9NMOYjih5PTitoNw62HZ9oIOxe6+LaLyt42dIu8/IVxKUU5INeJ6/R1wVZvzZ8GH PhctkqDp5XqkTO1B6yxud2gW1R4hDqFW0s5vExOXWnzvUkwOqY9Uh/o9/HwaHnB6XFhlKn48sHaw zRli3XCTSC2ZhO/KzoLYFHUDVExPfkJgrWzpm4QZXWzmwVnWHnE0ve+Rsw7DgW62+L1oZGEqjcoq iVWT7C6ks+HMU9b8HQREyQAkY8QEW9hSZH8LuCu9k8gPw9FtO6j1hDKcBCAvJC2dFxdN/9loyKA7 ICAUTBtiQwAAAAAAAA== --Apple-Mail-3-804846305-- 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-3-804846305 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Ooops: search table=LONGRANGE&neJ_UNITdatarq=[blank]&J_UNITsort=1&J_UNITsumm=T] [founditems] [J_UNIT] in [IN_AREA] has:
[search table=LONGRANGE&eqJ_UNITdatarq=[J_UNIT]&asT_AREAsort=1] [founditems] [T_AREA] in range.
[/founditems][/search] [/founditems][/search] On Nov 7, 2008, at 9:42 AM, Patrick McCormick wrote: > 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-3-804846305 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 9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wODExMDcxNTQ0MjZaMCMGCSqGSIb3 DQEJBDEWBBRRE1Ms8iF5/hWr2D0V/vyRT/vL0zCBhQYJKwYBBAGCNxAEMXgwdjBiMQswCQYDVQQG EwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhh d3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEBmvvAg5L6PclE8ruwo/gMYwgYcGCyqG SIb3DQEJEAILMXigdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcg KFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EC EBmvvAg5L6PclE8ruwo/gMYwDQYJKoZIhvcNAQEBBQAEggEAsxEYES1O4VU1ZVRqny3OGUOAIQtk M/uhTGnJhZHo9NMOYjih5PTitoNw62HZ9oIOxe6+LaLyt42dIu8/IVxKUU5INeJ6/R1wVZvzZ8GH PhctkqDp5XqkTO1B6yxud2gW1R4hDqFW0s5vExOXWnzvUkwOqY9Uh/o9/HwaHnB6XFhlKn48sHaw zRli3XCTSC2ZhO/KzoLYFHUDVExPfkJgrWzpm4QZXWzmwVnWHnE0ve+Rsw7DgW62+L1oZGEqjcoq iVWT7C6ks+HMU9b8HQREyQAkY8QEW9hSZH8LuCu9k8gPw9FtO6j1hDKcBCAvJC2dFxdN/9loyKA7 ICAUTBtiQwAAAAAAAA== --Apple-Mail-3-804846305-- 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:

The List is Changing (1997) WebCatalog2 Feature Feedback (1996) Grep and Special Characters (2002) Almost a there but..bye bye NetCloak (1997) multiple search commands (1997) To use GREP to boldface text (2003) TCP Connect for a newbie (2002) WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997) Re:no [search] with NT (1997) rn doesn't work on date fields (1998) all records returned. (1997) Experience with creating real dynamic solutions?????? (1998) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) Duplicate Hell (1999) Search Context Strips URL chrs.? (1999) WebCat2b15MacPlugIn - [authenticate] not [protect] (1997) [SearchString] usage (1997) Re:HTTP header line is too long? (1997) Country & Ship-to address & other fields ? (1997) Before I Can Begin . . . (1998)