Re: search problem
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 45165
interpreted = N
texte = >Specifying Ad_Numbertype=num tells WebDNA to convert BOTh the >value of the field and the value to which it is being compared to >numbers prior to performing any comparisons or sorting. > >It appears to be the same as enclosing the values inside [math] >contexts, which gives results like this: > >value as num >234ab 234 >a2 (blank) >33-ABC (blank) >123.45.67 123.45 >000321 321 > >So this generally wreaks havoc on any field that contains >non-numeric characters, and also eliminates any chance of a wo, >bw or similar comparison working. It can definitely screw up your >eq results as well - for example, with type=num, 123AB would match >00123XX, since the math would convert both values to 123. > >As a general rule, I do not use the type=num unless I need it for >sorting purposes.... and when you use it, make sure that none of the values you're searching for in that field are non-numeric. Because if they are non-numeric, your search will fail to find the records you might expect it to find. Sincerely, Kenneth Grome--------------------------------------------------- WebDNA Professional Training and Development Center 175 J. Llorente Street +63 (32) 255-6921 Cebu City, Cebu 6000 kengrome@webdna.net Philippines http://www.webdna.net ---------------------------------------------------------------------------------------------------------------- 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:
>Specifying Ad_Numbertype=num tells WebDNA to convert BOTh the >value of the field and the value to which it is being compared to >numbers prior to performing any comparisons or sorting. > >It appears to be the same as enclosing the values inside [math] >contexts, which gives results like this: > >value as num >234ab 234 >a2 (blank) >33-ABC (blank) >123.45.67 123.45 >000321 321 > >So this generally wreaks havoc on any field that contains >non-numeric characters, and also eliminates any chance of a wo, >bw or similar comparison working. It can definitely screw up your >eq results as well - for example, with type=num, 123AB would match >00123XX, since the math would convert both values to 123. > >As a general rule, I do not use the type=num unless I need it for >sorting purposes.... and when you use it, make sure that none of the values you're searching for in that field are non-numeric. Because if they are non-numeric, your search will fail to find the records you might expect it to find. Sincerely, Kenneth Grome--------------------------------------------------- WebDNA Professional Training and Development Center 175 J. Llorente Street +63 (32) 255-6921 Cebu City, Cebu 6000 kengrome@webdna.net Philippines http://www.webdna.net ---------------------------------------------------------------------------------------------------------------- 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/
Kenneth Grome
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:
Authorize.Net (2003)
WebCat editing, SiteGuard & SiteEdit (1997)
Sending order notification by fax (1999)
GD Spam (2003)
Ongoing group search problems ... (1997)
customers getting same cart (2004)
Emailer to include Human Name with email Address (2000)
Sku numbers (1997)
New public beta available (1997)
carriage returns in data (1997)
Apache 2.0 incompatible? (2005)
PCS Frames (1997)
One Hour Email (2002)
Display [price] in banner ad (1998)
[WebDNA] HTTP Streaming -- impossible? (2010)
WebDNA 4.5.1 on Apache 2.x. (2004)
show all problem (1997)
2.1 Stuff (1998)
RE: EXTERNAL EMAIL: [WebDNA] find missing file in [listfiles] (2019)
weird happenings (1997)