Re: Help with nested search
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 18304
interpreted = N
texte = >I think you need to summarize by organization rather than email. Then as>you find all the organizations, you can list all the emails within each of>those organizations.>>ORG1: <-- summarize by organization> email1 <-- emails within the organization> email2> email3>ORG2:> email1> email2>Thanks for the guidance, but it doesn't quite accomplish what I'mseeking... what I want to end up with is:email1: some - Org event1 event2 event3email2: some - Org event1 event2 event3So I need to summarize by email, than look at the resulting organizationfield and search to get a list of all the events that that org has listed.In some cases different emails may list the same org and then that org'sevents. That's because an organization may have entered in records withdiffering e-mail address. I need to send a list off all that org's eventsto ALL the email addresses associated with a give org.Would it be easier to do a [writefile] of the first search results into anew db and then doing some relational searching between the two dbs? So farthat the only way I can see of doing this.Thanka again-Marty
Associated Messages, from the most recent to the oldest:
>I think you need to summarize by organization rather than email. Then as>you find all the organizations, you can list all the emails within each of>those organizations.>>ORG1: <-- summarize by organization> email1 <-- emails within the organization> email2> email3>ORG2:> email1> email2>Thanks for the guidance, but it doesn't quite accomplish what I'mseeking... what I want to end up with is:email1: some - Org event1 event2 event3email2: some - Org event1 event2 event3So I need to summarize by email, than look at the resulting organizationfield and search to get a list of all the events that that org has listed.In some cases different emails may list the same org and then that org'sevents. That's because an organization may have entered in records withdiffering e-mail address. I need to send a list off all that org's eventsto ALL the email addresses associated with a give org.Would it be easier to do a
[writefile] of the first search results into anew db and then doing some relational searching between the two dbs? So farthat the only way I can see of doing this.Thanka again-Marty
Marty Schmid
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:
Ultimate BB (2001)
pc (1997)
Secure Server basic question... (1997)
WebCatalog Q & A pages (1997)
Kaaaaahhhhhhhnnnnnnn! (1997)
Templates for Customer Database? (1997)
available times? (2003)
The USArea® Network web site ... (1997)
Summing fields (1997)
setlineitem - textc and texte (2005)
WebCat2b15MacPlugin - [protect] (1997)
Maximum of found items?? (2000)
Size limit for tmpl editor ? (1997)
Robots fill event log (1997)
Emailer (1997)
Can I invoke an ssi plugin from within a webcat page (1997)
Possible Bug in 2.0b15.acgi (1997)
Forms Search Questions (1997)
Sorting error (1997)
Error: Too many nested [xxx] contexts (1997)