Re: Negative number search

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 28596
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] I think webcat only deals with whole numbers, so it sees them all as unsigned values, which makes them all 'positive' instead of some positive and some negative.Here's a solution, add a NEWNUM field to the db, then write an admin template that runs thru the db and replaces the value in the NEWNUM field with the value of SEARCH_FIELD plus XXX.The value of XXX will have to be greater than the absolute value of the smallest negative value in the db, so if the smallest negative value is -99 then add 100. Then in your search parameters, compare the values in the NEWNUM field instead of SEARCH_FIELD field.Maybe there's an easier way, but this will work as long as you remember to also write a value to the NEWNUM field after every append or replace ... :)================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://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 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] I think webcat only deals with whole numbers, so it sees them all as unsigned values, which makes them all 'positive' instead of some positive and some negative.Here's a solution, add a NEWNUM field to the db, then write an admin template that runs thru the db and replaces the value in the NEWNUM field with the value of SEARCH_FIELD plus XXX.The value of XXX will have to be greater than the absolute value of the smallest negative value in the db, so if the smallest negative value is -99 then add 100. Then in your search parameters, compare the values in the NEWNUM field instead of SEARCH_FIELD field.Maybe there's an easier way, but this will work as long as you remember to also write a value to the NEWNUM field after every append or replace ... :)================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://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 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:

& not allowed in db by definition? (1999) Text vs. Math (2000) ShowNext Command (1997) WebDNA Grep help wanted (2004) Mult-File Upload w/ Web Star (2000) Error handling for accountNum (1997) Web Delivery First Time Setup Trouble (2000) Performance Issue (2000) Testing (2002) Frames and WebCat (1997) send people in a database an email (2001) WebCatalog can't find database (1997) What abobut variables named max ??? (2000) Only charge card when product shipped ? (1997) Transferring [cart] to Database (1997) WebCat2 - Getting to the browser's username/password data (1997) WebCatalog f2 Installation (1997) Log-in Scheme (2003) WebCatalog NT (1996) wc 2 pro users - sites, quotes wanted (1997)