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:

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)