Help with nested search

This WebDNA talk-list message is from

1998

It keeps the original formatting. numero = 18299
interpreted = N
texte = I need a little help understanding the fundamentals of nesting a search.Here's my scenario: I have a database full of events - each record has theevent info, organization info and sometimes an e-mail address. Here's whatI'm trying to accomplish:1. Do a search for all records which contain @ in the OwnerEmail field -then summarize that by OwnerEmail so that I get a single list of all valide-mails and the associated organization name [text2].2. From those results, I'd like to do a nested search for all records whichhave the same organization value [text2] as each of the records foundduring the first search and return a list of all titles associated withthat organization. (my final objective will be to e-mail each organizationa list of all of their records in our database - but first things first...)My current code (which doesn't work of course)This is in a hyperlink on the first page:--------------------------------------This is on the results page:--------------------------------------[numfound][foundItems][text2][search db=catalog.txt&eqtext2datarq=[text2]][foundItems][Title]
[OwnerEmail][sku]

[/foundItems][/search][/foundItems]-------------------------------------------------------Currently I'm getting results that appear as though the summ-T is beingapplied in the first search (if I run it withouth the nested search I doget the reults I anticipated) but the nested search seems to ignore thesummarized results and starts a search based upon an un-summarized list ofresults of the outer search.I hope that makes some sense - My error is probably obvious to thosefamiliar with nesting searches but there no documentation of this and thesearchable archives were no help either. Thanks in advance for theassistance.-Marty Associated Messages, from the most recent to the oldest:

Re: Help with nested search (PCS Technical Support 1998) Re: Help with nested search (Marty Schmid 1998) Re: Help with nested search (PCS Technical Support 1998) Re: Help with nested search (Marty Schmid 1998) Re: Help with nested search (PCS Technical Support 1998) Help with nested search (Marty Schmid 1998)

I need a little help understanding the fundamentals of nesting a search.Here's my scenario: I have a database full of events - each record has theevent info, organization info and sometimes an e-mail address. Here's whatI'm trying to accomplish:1. Do a search for all records which contain @ in the OwnerEmail field -then summarize that by OwnerEmail so that I get a single list of all valide-mails and the associated organization name [text2].2. From those results, I'd like to do a nested search for all records whichhave the same organization value [text2] as each of the records foundduring the first search and return a list of all titles associated withthat organization. (my final objective will be to e-mail each organizationa list of all of their records in our database - but first things first...)My current code (which doesn't work of course)This is in a hyperlink on the first page:--------------------------------------This is on the results page:--------------------------------------[numfound][founditems][text2][search db=catalog.txt&eqtext2datarq=[text2]][founditems][Title]
[OwnerEmail][sku]

[/foundItems][/search][/foundItems]-------------------------------------------------------Currently I'm getting results that appear as though the summ-T is beingapplied in the first search (if I run it withouth the nested search I doget the reults I anticipated) but the nested search seems to ignore thesummarized results and starts a search based upon an un-summarized list ofresults of the outer search.I hope that makes some sense - My error is probably obvious to thosefamiliar with nesting searches but there no documentation of this and thesearchable archives were no help either. Thanks in advance for theassistance.-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:

BUG REPORT -- Refusing connections! (1999) Catch MySQL Connection error (2005) shipcost and Formulas.db (2000) triggers.db (1999) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) SMSI, please respond: Unanswered trigger questions ... (2003) PCS Frames (1997) WebDNA Solutions ... sorry! (1997) Sales Tax db (1998) WebCat b13 CGI -shownext- (1997) eMail volume (2000) Trouble with formula.db (1997) WebDNA - fun to compare (2005) Bug or syntax error on my part? (1997) WebCatalog [FoundItems] Problem - AGAIN - (1997) A Global Variable (1997) Submit buttons not working.... (1999) international time (1997) database paths/names, and a typo (1997) Re:listfiles-looking for slick solution (1997)