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:
RAM variables (1997)
changing banners on a page without refresh? (2000)
Fwd: Problems with Webcatalog Plug-in (1997)
I'm new be kind (1997)
[NT] ie 4.0 required (1997)
Reindexing a db with duplicate numbers... (1999)
docs for WebCatalog2 (1997)
Any word on upload feature? (2000)
Using [showif] within [lineitems] [code fragment] (2000)
Search: Is this possible? (2005)
[WebDNA] fastcgi 7+ & [cart]? (2010)
[searchString] (1997)
searchable list archive (1997)
[WriteFile] problems (1997)
Multiple cart additions (1997)
Answer: WebDelivery downloads alias, not original ? (1997)
Date or time comparisons have bugs ... (1998)
Error Lob.db records error message not name (1997)
This message couldn't reach the list! (multi-column (1998)
WebDNA vs SQL ? (2002)