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:
Dynamic Generation of PDFs? (2003)
Can you do this??? and other stuff (1997)
Unzip (2005)
[WebDNA] Code to display a RSS feed (2019)
Fwd: FW: Purchase Command error (1997)
[shownext max=?] armed (1997)
RE: CloseDatabase (1997)
E-mail/Invoice (1998)
database consultant needed (1998)
Help name our technology! (1997)
redirect with frames (1997)
WebCatalog can't find database (1997)
Frames and WebCat (1997)
Reminder... (2003)
all records returned. (1997)
WebCat2final1 crashes (1997)
RE: Formulas.db + Users.db (1997)
[referrer] -truncates at & (1998)
Quickie question on the email templates (1997)
OLD ORDERS (1998)