Re: Searching for Email Address

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 57763
interpreted = N
texte = I have an old guestbook example that uses the following. Guest.db has the following fields EMAILNAMENOTEDATE
Search For :
In the email address

In the name

In the Notes
Results.dna [SEARCH db=guests.db&[EMAILCOMP]EMAILdatarq=[INADDRESS]&woNAMEdatarq=[INNAME]&woNOTE datarq=[INNOTE]&EMAILsort=1&max=25&startat=[startat]] Number of records found: [NUMFOUND]

[FOUNDITEMS] [/FOUNDITEMS]
E-Mail AddressName
[EMAIL][NAME]RemoveEditEmail Them
-----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of Vincent Medina Sent: Tuesday, May 11, 2004 6:28 PM To: WebDNA Talk Subject: Searching for Email Address 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 ------------------------------------------------------------- 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/ __________ NOD32 1.757 (20040511) Information __________ This message was checked by NOD32 Antivirus System. http://www.nod32.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:

    
  1. Re: Searching for Email Address ( "Vincent Medina" 2004)
  2. Re: Searching for Email Address ( Donovan Brooke 2004)
  3. Re: Searching for Email Address ( Brian Fries 2004)
  4. Re: Searching for Email Address ( Donovan Brooke 2004)
  5. Re: Searching for Email Address ( Donovan Brooke 2004)
  6. Re: Searching for Email Address ( Brian Fries 2004)
  7. Re: Searching for Email Address ( "Sal" 2004)
  8. Re: Searching for Email Address ( "Sal" 2004)
  9. Re: Searching for Email Address ( "Sal" 2004)
  10. Re: Searching for Email Address ( "Gary Krockover" 2004)
  11. Re: Searching for Email Address ( Donovan Brooke 2004)
  12. Searching for Email Address ( "Vincent Medina" 2004)
I have an old guestbook example that uses the following. Guest.db has the following fields EMAILNAMENOTEDATE
Search For :
In the email address

In the name

In the Notes
Results.dna [SEARCH db=guests.db&[EMAILCOMP]EMAILdatarq=[INADDRESS]&woNAMEdatarq=[INNAME]&woNOTE datarq=[INNOTE]&EMAILsort=1&max=25&startat=[startat]] Number of records found: [NUMFOUND]

[founditems] [/FOUNDITEMS]
E-Mail AddressName
[EMAIL][NAME][url][EMAIL][/URL]">Remove[url][EMAIL][/URL]">Edit[url][EMAIL][/URL]&EMAILCOMP=eq&INNAME=&INNOTE= ">Email Them
-----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of Vincent Medina Sent: Tuesday, May 11, 2004 6:28 PM To: WebDNA Talk Subject: Searching for Email Address 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 ------------------------------------------------------------- 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/ __________ NOD32 1.757 (20040511) Information __________ This message was checked by NOD32 Antivirus System. http://www.nod32.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/ "Sal"

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! WebCat2 bug (1997) 2 databases problem (1997) WCS Newbie question (1997) For those of you not on the WebCatalog Beta... (1997) Why isn't this working (1999) Search Form (2000) Configuration Q (1998) WebCatalog for Postcards ? (1997) Setting up shop (1997) Help formatting search results w/ table (1997) Calculating days, hours, minutes ago (2004) Grep Search and Replace (2002) Close-to Comparison Code (1998) Error Log.db --however (1997) Country & Ship-to address & other fields ? (1997) emailer w/F2 (1997) ConvertChars (2000) Some pointers please (2008) Replace Statement (1997) WebCat2b15MacPlugin - showing [math] (1997)