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