Re: search problem
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 45163
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 321So 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.- brianAt 10:29 PM 11/12/02, Frank Nordberg wrote: >Ken MacMurchy wrote: > >... >> >>This does not work: >>[search db=classpic.db&eqAD_Numberdatarq=[Ad_Number]&Ad_Numbertype=num] > > >A bit off topic perhaps, but what's the &Ad_Numbertype=num for? >Isn't that a bit superfluous if you're looking for one single exact >match? > >(Come to think of it, I see the origial post described [Ad_Number] >as a _text_ field. What happens if you ask WebCatalog to treat a >field as number field if it doesn't contain a strictly numeric >value?) > >Frank Nordberg >http://www.musicaviva.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:
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 321So 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.- brianAt 10:29 PM 11/12/02, Frank Nordberg wrote: >Ken MacMurchy wrote: > >... >> >>This does not work: >>[search db=classpic.db&eqAD_Numberdatarq=[Ad_Number]&Ad_Numbertype=num] > > >A bit off topic perhaps, but what's the &Ad_Numbertype=num for? >Isn't that a bit superfluous if you're looking for one single exact >match? > >(Come to think of it, I see the origial post described [Ad_Number] >as a _text_ field. What happens if you ask WebCatalog to treat a >field as number field if it doesn't contain a strictly numeric >value?) > >Frank Nordberg >http://www.musicaviva.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/
Brian Fries
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:
FWD: Autoproxy Bug with WebCatalog and FireSite (1997)
Web*3 virtual hosting Webcatalog problem + Vicom bonus (1998)
Postprocessing CCs (2000)
upgrading (1997)
Exclude by date - multiple (1997)
Not reading code (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
Separate SSL Server (1997)
How to archive....? (1998)
[item] appears after 'remove last item' ... (1997)
random within a specified range (2001)
previous orders (2002)
emailer w/F2 (1997)
Date fun with MySQL (2004)
authnet good news (2003)
Bug Report, maybe (1997)
Listfiles and nothing found (2001)
Navigator 4.01 (1997)
WebCatalog can't find database (1997)
[WebDNA] backup / mirror website & databases (2018)