Negative number search

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 28591
interpreted = N
texte = I need to search on a field that has negative numbers in it. I am looking for a search range from -20 to 0 but I can not seem to get it to work. Here is what I have tried:[search db=/database.db&rnSEARCH_FIELDdatarq=-20 0&SEARCH_FIELD type=num&OTHER_FIELD sort=1][search db=/database.db&rnSEARCH_FIELDdatarq=[math]-20[/math] 0&SEARCH_FIELD type=num&OTHER_FIELD sort=1] I even tried this to see if I could get a negative number recognized, but it only brought back results higher than +20[search db=/database.db&geSEARCH_FIELDdatarq=-20&SEARCH_FIELD type=num&OTHER_FIELD sort=1]Any help would be greatly appreciated.Thanks all:-)|--------------------------------------| | Get Real Gear, Inc. | P.O. Box 11199 | Aspen, CO 81612 | fax/voice (970)544-0527 | paul@gearworld.com | http://www.gearworld.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 Associated Messages, from the most recent to the oldest:

    
  1. Re: Negative number search (Paul Fowler 2000)
  2. Re: Negative number search (Kenneth Grome 2000)
  3. Negative number search (Paul Fowler 2000)
I need to search on a field that has negative numbers in it. I am looking for a search range from -20 to 0 but I can not seem to get it to work. Here is what I have tried:[search db=/database.db&rnSEARCH_FIELDdatarq=-20 0&SEARCH_FIELD type=num&OTHER_FIELD sort=1][search db=/database.db&rnSEARCH_FIELDdatarq=[math]-20[/math] 0&SEARCH_FIELD type=num&OTHER_FIELD sort=1] I even tried this to see if I could get a negative number recognized, but it only brought back results higher than +20[search db=/database.db&geSEARCH_FIELDdatarq=-20&SEARCH_FIELD type=num&OTHER_FIELD sort=1]Any help would be greatly appreciated.Thanks all:-)|--------------------------------------| | Get Real Gear, Inc. | P.O. Box 11199 | Aspen, CO 81612 | fax/voice (970)544-0527 | paul@gearworld.com | http://www.gearworld.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 Paul Fowler

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:

database freeze (1997) The IBC root beer has arrived! (1997) WebCatalog/WebMerchant 2.1 (1998) $Quit, $CloseDatabase corrections (1997) MacFinder -- a new WebDNA web site (1998) Tax on shipping (1998) Header Values won't take. (1998) variable value locked when passed to include (2001) [WriteFile] problems (1997) search form problem.. (1997) Sendmail (2000) HTML tags inside textarea (2000) CAll me Crazy (2000) Banner Ad (1998) RE: Renaming textA (1998) [append] vs. [appendfile] delta + question? (1997) Review comparison by PC Magazine: Open for On-line Business (1997) European Convention (2004) remotely add + sign (1997) Secure Server (1997)