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:

Multiple 'Users.db' files not possible (1997) Copyright that puppy (1998) Major NT problem Interruption of service (1998) Is [upload] avail. in 3.0.8 for NT? (2000) [Replace] really replaces? (2000) WebDNA Developer Resource Center (2002) RequiredFields notes ... (1997) RE: [redirect] w/o showing args? (1999) Sami (1998) WebCat2.0 acgi vs plugin (1997) Passing Cart variable to subdirectory files? (1997) Requiring that certain fields be completed (1997) PDF (1999) Nested tags count question (1997) Hyperboard/bulletin board available (1998) Bug Report, maybe (1997) b18 problem on NT 4.0 (1997) Webcatalog on MacOs (2000) [OT] 'Email this story to a friend' (2003) Robert Minor duplicate mail (1997)