Bad match!

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 42970
interpreted = N
texte = This may be an old rehash but:What's wrong with this search?[Search db=some.db&eqFIRST_NAMEdatarq=[FIRST_NAME]&eqLAST_NAMEdatarq=[LAST_NAME]] . . .I need to return results if (and only if) both FIRST_NAME and LAST_NAME match. What's happening is that if [LAST_NAME] = nothing or is left blank in the form this search still returns the first match it finds in [FIRST_NAME] if there is one.In other words the user can put joe in the form field FIRST_NAME and leave the LAST_NAME field blank and this search will return with a record for user Joe.Any ideas what the heck I'm doing wrong here?Thanks in advanceSigned: Marc Kaiwi San Diego Motorcycle Club: http://www.sdmotorcycleclub.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://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Bad match! (Alain Russell 2002)
  2. Re: Bad match! (Donovan 2002)
  3. Re: Bad match! (Gary Krockover 2002)
  4. Re: Bad match! (Marc Kaiwi 2002)
  5. Re: Bad match! (Gary Krockover 2002)
  6. Bad match! (Marc Kaiwi 2002)
This may be an old rehash but:What's wrong with this search?[Search db=some.db&eqFIRST_NAMEdatarq=[FIRST_NAME]&eqLAST_NAMEdatarq=[LAST_NAME]] . . .I need to return results if (and only if) both FIRST_NAME and LAST_NAME match. What's happening is that if [LAST_NAME] = nothing or is left blank in the form this search still returns the first match it finds in [FIRST_NAME] if there is one.In other words the user can put joe in the form field FIRST_NAME and leave the LAST_NAME field blank and this search will return with a record for user Joe.Any ideas what the heck I'm doing wrong here?Thanks in advanceSigned: Marc Kaiwi San Diego Motorcycle Club: http://www.sdmotorcycleclub.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://search.smithmicro.com/ Marc Kaiwi

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:

How do you TEAM Code? (2004) [searchString] (1997) typhoon... (1997) Here we go again...WebDNA - SQL- Clustering (2006) [WebDNA] Libmysql.dll error (2009) Re:Emailer and encryption (1997) [WebDNA] WebDNA vs. php war ;-) (2010) TemplateCacheSize preference! (1998) RE: Answer: WebDelivery downloads alias, not original ? (1997) woops - speed results - right subject (2002) WebCat2b12--[searchstring] bug (1997) Dates and Math - Simple Subtraction (2004) textarea inputs and returns (1999) Listfiles & writefile (2001) WebCommerce: Folder organization ? (1997) (2000) Logging purchases (1997) [SHOWIF AND/OR] (1997) Re:2nd WebCatalog2 Feature Request (1996) Emailer choke (1997)