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:
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)