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

Re: Negative number search (Paul Fowler 2000)
Re: Negative number search (Kenneth Grome 2000)
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 Consultant808-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!

Re: Negative number search

2000

Top Articles:

Related Readings: