Re: Bad match!

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 42971
interpreted = N
texte = add this to the search:&allBLNK=TGK | 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 advance | | Signed: 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/ ------------------------------------------------------------- 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)
add this to the search:&allBLNK=TGK | 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 advance | | Signed: 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/ ------------------------------------------------------------- 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/ Gary Krockover

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:

The Depths of Credit Card Payment (2003) Db crash in win98 (2000) Search design (1997) bug in [SendMail] (1997) Grep Question (2003) Introduction/Tutorial/QuickStart (1997) test - ignore (2008) Integration with SQL (1997) variables in template (2000) ShipCosts database (1997) WCS Newbie question (1997) Webcat table size. (2001) NT vs Mac (1997) WebCommerce: Folder organization ? (1997) Random question (1998) Counting LineItems (2000) using showpage and showcart commands (1996) OT: Need some feedback, please. (2003) can WC render sites out? (1997) Here's how to kill a Butler Database. (1997)