Re: Searching an Email database
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 12925
interpreted = N
texte = >>[search db=account.log&eqEMAILdata=eschrieffer@creativeedge.com]>>[NumFound]>>[/search]>>>>This returns the count of every Email address.>>>>If I pull out the at symbol, @, it works great.>>>>Is this a special character for webDNA? Like the ampersand, &, is>>used for linking?>>>>Can a search for Email addresses be done?If @ is reserved, how about trying the following search:[search db=account.log&bwEMAILdatarq=eschrieffer&woEMAILdatarq=creativeedge.com][NumFound][/search]If the above doesn't work, something like this should (haven't tested though):[search db=account.log&bwEMAILdatarq=eschrieffer] [foundItems] [showif [EMAIL]^creativeedge.com] [math]numHold=numHold+1[/math] [/showif] [/foundItems] Number Found = [math]numHold[/math][/search]Happy Aloha Friday,Olin.....................................................................W O R L D P O I N T I N T E R A C T I V E OLIN KEALOHA LAGON director, website creationHonolulu San Francisco 2800 woodlawn drive 222 sutter street olin@worldpoint.com suite 170 sixth floor www.worldpoint.com honolulu, hi 96822 san francisco, ca 94108 voice.808.539.3978 fax.808.539.3943 cell.808.291.1610.....................................................................
Associated Messages, from the most recent to the oldest:
>>[search db=account.log&eqEMAILdata=eschrieffer@creativeedge.com]>>[NumFound]>>[/search]>>>>This returns the count of every Email address.>>>>If I pull out the at symbol, @, it works great.>>>>Is this a special character for webDNA? Like the ampersand, &, is>>used for linking?>>>>Can a search for Email addresses be done?If @ is reserved, how about trying the following search:[search db=account.log&bwEMAILdatarq=eschrieffer&woEMAILdatarq=creativeedge.com][NumFound][/search]If the above doesn't work, something like this should (haven't tested though):[search db=account.log&bwEMAILdatarq=eschrieffer] [math]numHold=0[/math]>
[founditems] [showif [EMAIL]^creativeedge.com]
[math]numHold=numHold+1[/math] [/showif] [/foundItems] Number Found =
[math]numHold[/math][/search]Happy Aloha Friday,Olin.....................................................................W O R L D P O I N T I N T E R A C T I V E OLIN KEALOHA LAGON director, website creationHonolulu San Francisco 2800 woodlawn drive 222 sutter street olin@worldpoint.com suite 170 sixth floor www.worldpoint.com honolulu, hi 96822 san francisco, ca 94108 voice.808.539.3978 fax.808.539.3943 cell.808.291.1610.....................................................................
Olin
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:
Help with WebCatalog (1998)
Email Formatting and Encryption (1998)
Webcatalog server support (1997)
Frames (1997)
Emailer pref's won't save (2005)
Webcat 4.0 and security (2000)
Database Advice (1996)
Emailer setup (1997)
[WebDNA] Is a '.webdna' suffix better? (2008)
Email template names (1997)
Searching/sorting dates (1997)
Sorting Results (1999)
WebCatalog [FoundItems] Problem - AGAIN - (1997)
&fieldsdir=ra truely random?? (2000)
lookups or math? (1998)
RE: WebDNA-Talk searchable? (1997)
Refering page (1998)
RE: what characters are replaced for tab and CR? (1998)
Adding Message to Order (1997)
Emailer problem....still (1997)