Re: Strange Search Results
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 56044
interpreted = N
texte = Justin Carroll wrote: > Why, when you type in "aslfkjsdlfj" or anything BESIDES a number, does it > return sku 1 and 3 but not 2? Thanks. > Because _any_ text (i.e. not a number) is equal to the number 0, and hence matches records 1 & 3. You will need to change your [search] context based on whether the [txtKeyword] field contains a number or not. You should probably be preprocessing the search term anyway to ensure that "search by date" is actually done with a date in the legal range (i.e. not 0). HTH John -- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4501 Forbes Boulevard Suite H Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5748 ------------------------------------------------------------- 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:
Justin Carroll wrote: > Why, when you type in "aslfkjsdlfj" or anything BESIDES a number, does it > return sku 1 and 3 but not 2? Thanks. > Because _any_ text (i.e. not a number) is equal to the number 0, and hence matches records 1 & 3. You will need to change your [search] context based on whether the [txtKeyword] field contains a number or not. You should probably be preprocessing the search term anyway to ensure that "search by date" is actually done with a date in the legal range (i.e. not 0). HTH John -- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4501 Forbes Boulevard Suite H Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5748 ------------------------------------------------------------- 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/
John Peacock
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:
creator code (1997)
Proper file locations (1997)
WebCat2b13MacPlugIn - [include] (1997)
Max Record length restated as maybe bug (1997)
Emailer on NT not working. (1999)
[WebDNA] XML Parser (2016)
RE: Answer: WebDelivery downloads alias, not original ? (1997)
ShoppingCarts (2000)
Searching a database... (2003)
quotation marks (2004)
Generating Options for a Form. (1997)
Help with nested search (1998)
SHOWIF/HIDEIF empty fields (2005)
[WebDNA] cant't restart webcatalog missing libcrypto.so.0.9.8 (2014)
$purchase WITHOUT creditcar (1997)
default value from Lookup (was Grant, please help me) (1997)
Orderfile Info is Dissappearing (1998)
Help name our technology! (1997)
Here's an example of an applet in a tpl (1997)
WebCatalog can't find database (1997)