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 creation Honolulu 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:

    
  1. Re: Searching an Email database (Olin 1997)
  2. Re: Searching an Email database (grichter@panavise.com (Gary Richter) 1997)
  3. Re: Searching an Email database (Eddie Schrieffer 1997)
>>[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 creation Honolulu 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)