Re: Searching for Email Address
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 57768
interpreted = N
texte = Try using a "ws" (whole string) comparison instead of a "wo" (word or). With "wo" you'll be finding every record with the word "com" in it, because the period is a standard word break character. Alternatively, you could use a "wbrk" parameter in your search to specify what characters define word breaks (see the docs under Searching / Word Breaks) - brian On May 11, 2004, at 6:27 PM, Vincent Medina wrote: > I have a search query like the one below: > > [search > db=../db/ > customers.db&group1field=bcompanyname+bcontactname+email_address&wo > group1data=[keyword]&max=50&email_addresssort=1] > > If use the value for keyword: test@email.com > > And there is a valid record with test@email.com set in the > email_address > field; WC returns all the records in the database. > > Why? > > Windows EXE version 4.0.2 > -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.com -- ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Try using a "ws" (whole string) comparison instead of a "wo" (word or). With "wo" you'll be finding every record with the word "com" in it, because the period is a standard word break character. Alternatively, you could use a "wbrk" parameter in your search to specify what characters define word breaks (see the docs under Searching / Word Breaks) - brian On May 11, 2004, at 6:27 PM, Vincent Medina wrote: > I have a search query like the one below: > > [search > db=../db/ > customers.db&group1field=bcompanyname+bcontactname+email_address&wo > group1data=[keyword]&max=50&email_addresssort=1] > > If use the value for keyword: test@email.com > > And there is a valid record with test@email.com set in the > email_address > field; WC returns all the records in the database. > > Why? > > Windows EXE version 4.0.2 > -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.com -- ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Brian Fries
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:
Webmerch tags? (1998)
Counting records (2000)
problems with 2 tags (1997)
quick GREP question (2001)
incrementing a counter remotely? (1999)
[WebDNA] paypal FINALLY!!!! (2009)
[date format] w/in sendmail (1997)
[WebDNA] [ipaddress] - [RealIP] - Not working properly (2016)
mass mailing (1998)
MacActivity and PCS (1997)
Comments in db? (1997)
webcat2b12 CGI -- Date comparisons (1997)
Storebuilder-AutoCategory (2003)
Summing fields (1997)
Extended [ConvertChars] (1997)
greater than or equal to (1997)
ACGI processing for .html (1997)
WebCatalog can't find database (1997)
OS X permissions to write to Globals directory (2003)
WebSTAR, OSX, WebDNA permissions problem ... (2005)