Re: Help with nested search
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 18302
interpreted = N
texte = >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 valid >e-mails and the associated organization name [text2].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
[search db=catalog.txt&eqtext2datarq=[text2]&woOwnerEmaildatarq=@]The documented example is in the online docs in the Searching section under Multiple DatabasesTechnical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>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 valid >e-mails and the associated organization name [text2].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
[search db=catalog.txt&eqtext2datarq=[text2]&woOwnerEmaildatarq=@]The documented example is in the online docs in the Searching section under Multiple DatabasesTechnical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
PCS Technical Support
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, maybe (1997)
WebMerchant -- Sweeping WebDelivery < 24 hrs (2000)
Superfilous Characters (1998)
Busted at the Border (1998)
What file? (1997)
Great product and great job ! (1997)
Been meaning to ask... (1997)
It just Does't add up!!! (1997)
[OT] CSS div/span (2004)
WebCatalog/Mac 2.1b2 New Features (1997)
WebDNA problem (2006)
[searchString] (1997)
Help! WebCat2 bug (1997)
Unexpected error (1997)
WebCatalog 4.0 has been released! (2000)
[WriteFile] problems (1997)
two unique banners on one page (1997)
Encrypting WebDNA Templates (1999)
object tag examples (2004)
(1997)