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:

new cart IDs being assigned somehow (1997) WebDNA Fusebox was (European Convention) (2004) PDF Tools (2006) Docs error: encrypting templates... (2000) PCS Emailer's role ? (1997) Calendar using WebCatalog? (1997) [WebDNA] Another strange WebDNA problem (2013) Items XX to XX shown (1997) Lookup command (1998) Reminder... (2003) WebCat2 several catalogs? (1997) multiple credit card merchant accounts/processors (1997) WebCat2: Formulas.db question (1997) small hairball -- stuck on [showif] for related db (1998) Where is f2? (1997) Server crashes when user saves or views html source (1998) Progress !! WAS: Trouble with formula.db (1997) carriage returns in data (1997) Credit card processing - UK (1997) Weird Linux WebCat Issue (2003)