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-804846305Content-Type: text/plain;charset=US-ASCII;format=flowed;delsp=yesContent-Transfer-Encoding: 7bitOoops: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-804846305Content-Disposition: attachment;filename=smime.p7sContent-Type: application/pkcs7-signature;name=smime.p7sContent-Transfer-Encoding: base64MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGGTCCAtIwggI7oAMCAQICEBmvvAg5L6PclE8ruwo/gMYwDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA4MDkyNzAxMTg1M1oXDTA5MDkyNzAxMTg1M1owPjEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEbMBkGCSqGSIb3DQEJARYMcG1Ad2ViZG5hLnVzMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAtb7ZYYJV7sbgqxdgpBU/qCRsIJYGNIo40L9odKmo6Y/mPBybeSry8KefqmuWoBXxc6xCvSSJDWFcb2sZ+TkedZrdxvtoL1pHNjDZNe2ow+RCNUvJcQd1+ASzh0J4QLHnNyoMY3zuCQwqM6hK5gU4AlpOSITekksSFuGXBdJTjSeIgIpZFTTrd1c/Zv7miT9gO5UmHiyDClKP8oX31YFlb3q9EM2p8WQzb2Ce2M9kokCs8ZnhT+fRNc/Q9lc4RJtEuf3zynvg0cCbf71pgoC0Zepsop466jrvc08MsxxzRJDmjw20ci/3ltk+iAcD3TchYppwyX4HZhjrrZXcOMBMkQIDAQABoykwJzAXBgNVHREEEDAOgQxwbUB3ZWJkbmEudXMwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQUFAAOBgQCBMxqOGsLwOxtLQ8YLvOQOym8UQyB0CiF0Dpd0oOA+hjD5n9A1eileTd8OdkdPIb+der2Kw42N/UKARNSSkmn1hhKrgwTNYLyXFNlB+TJ2YvG13B27d4EaUdSn2KWKDKG4w14lQSO9y+RTjMSuYi4kbeI50QHLZsTZDO3OhNcKjzCCAz8wggKooAMCAQICAQ0wDQYJKoZIhvcNAQEFBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRpZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1haWxAdGhhd3RlLmNvbTAeFw0wMzA3MTcwMDAwMDBaFw0xMzA3MTYyMzU5NTlaMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAxKY8VXNV+065yplaHmjAdQRwnd/p/6Me7L3N9VvyGna9fww6YfK/Uc4B1OVQCjDXAmNaLIkVcI7dyfArhVqqP3FWy688Cwfn8R+RNiQqE88r1fOCdz0Dviv+uxg+B79AgAJk16emu59l0cUqVIUPSAR/p7bRPGEEQB5kGXJgt/sCAwEAAaOBlDCBkTASBgNVHRMBAf8ECDAGAQH/AgEAMEMGA1UdHwQ8MDowOKA2oDSGMmh0dHA6Ly9jcmwudGhhd3RlLmNvbS9UaGF3dGVQZXJzb25hbEZyZWVtYWlsQ0EuY3JsMAsGA1UdDwQEAwIBBjApBgNVHREEIjAgpB4wHDEaMBgGA1UEAxMRUHJpdmF0ZUxhYmVsMi0xMzgwDQYJKoZIhvcNAQEFBQADgYEASIzRUIPqCy7MDaNmrGcPf6+svsIXoUOWlJ1/TCG4+DYfqi2fNi/A9BxQIJNwPP2t4WFiw9k6GX6EsZkbAMUaC4J0niVQlGLH2ydxVyWN3amcOY6MIE9lX5Xa9/eH1sYITq726jTlEBpbNU1341YheILcIRk13iSx0x1G/11fZU8xggMQMIIDDAIBATB2MGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQQIQGa+8CDkvo9yUTyu7Cj+AxjAJBgUrDgMCGgUAoIIBbzAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wODExMDcxNTQ0MjZaMCMGCSqGSIb3DQEJBDEWBBRRE1Ms8iF5/hWr2D0V/vyRT/vL0zCBhQYJKwYBBAGCNxAEMXgwdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEBmvvAg5L6PclE8ruwo/gMYwgYcGCyqGSIb3DQEJEAILMXigdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEBmvvAg5L6PclE8ruwo/gMYwDQYJKoZIhvcNAQEBBQAEggEAsxEYES1O4VU1ZVRqny3OGUOAIQtkM/uhTGnJhZHo9NMOYjih5PTitoNw62HZ9oIOxe6+LaLyt42dIu8/IVxKUU5INeJ6/R1wVZvzZ8GHPhctkqDp5XqkTO1B6yxud2gW1R4hDqFW0s5vExOXWnzvUkwOqY9Uh/o9/HwaHnB6XFhlKn48sHawzRli3XCTSC2ZhO/KzoLYFHUDVExPfkJgrWzpm4QZXWzmwVnWHnE0ve+Rsw7DgW62+L1oZGEqjcoqiVWT7C6ks+HMU9b8HQREyQAkY8QEW9hSZH8LuCu9k8gPw9FtO6j1hDKcBCAvJC2dFxdN/9loyKA7ICAUTBtiQwAAAAAAAA==--Apple-Mail-3-804846305--
Associated Messages, from the most recent to the oldest:
--Apple-Mail-3-804846305Content-Type: text/plain;charset=US-ASCII;format=flowed;delsp=yesContent-Transfer-Encoding: 7bitOoops: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-804846305Content-Disposition: attachment;filename=smime.p7sContent-Type: application/pkcs7-signature;name=smime.p7sContent-Transfer-Encoding: base64MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGGTCCAtIwggI7oAMCAQICEBmvvAg5L6PclE8ruwo/gMYwDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA4MDkyNzAxMTg1M1oXDTA5MDkyNzAxMTg1M1owPjEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEbMBkGCSqGSIb3DQEJARYMcG1Ad2ViZG5hLnVzMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAtb7ZYYJV7sbgqxdgpBU/qCRsIJYGNIo40L9odKmo6Y/mPBybeSry8KefqmuWoBXxc6xCvSSJDWFcb2sZ+TkedZrdxvtoL1pHNjDZNe2ow+RCNUvJcQd1+ASzh0J4QLHnNyoMY3zuCQwqM6hK5gU4AlpOSITekksSFuGXBdJTjSeIgIpZFTTrd1c/Zv7miT9gO5UmHiyDClKP8oX31YFlb3q9EM2p8WQzb2Ce2M9kokCs8ZnhT+fRNc/Q9lc4RJtEuf3zynvg0cCbf71pgoC0Zepsop466jrvc08MsxxzRJDmjw20ci/3ltk+iAcD3TchYppwyX4HZhjrrZXcOMBMkQIDAQABoykwJzAXBgNVHREEEDAOgQxwbUB3ZWJkbmEudXMwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQUFAAOBgQCBMxqOGsLwOxtLQ8YLvOQOym8UQyB0CiF0Dpd0oOA+hjD5n9A1eileTd8OdkdPIb+der2Kw42N/UKARNSSkmn1hhKrgwTNYLyXFNlB+TJ2YvG13B27d4EaUdSn2KWKDKG4w14lQSO9y+RTjMSuYi4kbeI50QHLZsTZDO3OhNcKjzCCAz8wggKooAMCAQICAQ0wDQYJKoZIhvcNAQEFBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRpZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1haWxAdGhhd3RlLmNvbTAeFw0wMzA3MTcwMDAwMDBaFw0xMzA3MTYyMzU5NTlaMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAxKY8VXNV+065yplaHmjAdQRwnd/p/6Me7L3N9VvyGna9fww6YfK/Uc4B1OVQCjDXAmNaLIkVcI7dyfArhVqqP3FWy688Cwfn8R+RNiQqE88r1fOCdz0Dviv+uxg+B79AgAJk16emu59l0cUqVIUPSAR/p7bRPGEEQB5kGXJgt/sCAwEAAaOBlDCBkTASBgNVHRMBAf8ECDAGAQH/AgEAMEMGA1UdHwQ8MDowOKA2oDSGMmh0dHA6Ly9jcmwudGhhd3RlLmNvbS9UaGF3dGVQZXJzb25hbEZyZWVtYWlsQ0EuY3JsMAsGA1UdDwQEAwIBBjApBgNVHREEIjAgpB4wHDEaMBgGA1UEAxMRUHJpdmF0ZUxhYmVsMi0xMzgwDQYJKoZIhvcNAQEFBQADgYEASIzRUIPqCy7MDaNmrGcPf6+svsIXoUOWlJ1/TCG4+DYfqi2fNi/A9BxQIJNwPP2t4WFiw9k6GX6EsZkbAMUaC4J0niVQlGLH2ydxVyWN3amcOY6MIE9lX5Xa9/eH1sYITq726jTlEBpbNU1341YheILcIRk13iSx0x1G/11fZU8xggMQMIIDDAIBATB2MGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWluZyBDQQIQGa+8CDkvo9yUTyu7Cj+AxjAJBgUrDgMCGgUAoIIBbzAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wODExMDcxNTQ0MjZaMCMGCSqGSIb3DQEJBDEWBBRRE1Ms8iF5/hWr2D0V/vyRT/vL0zCBhQYJKwYBBAGCNxAEMXgwdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEBmvvAg5L6PclE8ruwo/gMYwgYcGCyqGSIb3DQEJEAILMXigdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEBmvvAg5L6PclE8ruwo/gMYwDQYJKoZIhvcNAQEBBQAEggEAsxEYES1O4VU1ZVRqny3OGUOAIQtkM/uhTGnJhZHo9NMOYjih5PTitoNw62HZ9oIOxe6+LaLyt42dIu8/IVxKUU5INeJ6/R1wVZvzZ8GHPhctkqDp5XqkTO1B6yxud2gW1R4hDqFW0s5vExOXWnzvUkwOqY9Uh/o9/HwaHnB6XFhlKn48sHawzRli3XCTSC2ZhO/KzoLYFHUDVExPfkJgrWzpm4QZXWzmwVnWHnE0ve+Rsw7DgW62+L1oZGEqjcoqiVWT7C6ks+HMU9b8HQREyQAkY8QEW9hSZH8LuCu9k8gPw9FtO6j1hDKcBCAvJC2dFxdN/9loyKA7ICAUTBtiQwAAAAAAAA==--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)