On 20 Dec 2017, at 10:01, Brian Fries <iphonzie@gmail.com> =wrote:---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero=3D55Bug Reporting: support@webdna.us[blank] only works with text comparisons, not numeric =comparisons.Because you set ==E2=80=9CIDType=3Dnum=E2=80=9D, WebDNA is converting the comparison =value ([blank}) to a number. Since it is an invalid number, it uses the =value 0.So this =gets interpreted by WebDNA as =E2=80=9CneIDdata=3D0=E2=80=9DIf you instead use ==E2=80=9CneIDdata=3D999999=E2=80=9D or another number you know won=E2=80=99=t be there, then you will see the zero.- Brian FriesOn Dec 19, 2017, at 2:41 PM, Michael Davis <admin@network13.net>= wrote:[writefile file=3Dsorttest.db]ID<tab>name
-2<tab>-2
-1<tab>-1
0<tab>0
1<tab>1
2<tab>2
[/writefile]
[search =db=3Dsorttest.db&neIDdata=3D[blank]&asIDsort=3D1&IDtype=3Dnum]=
=[founditems]
[name]<br>
=[/founditems]
[/search]
|
On 20 Dec 2017, at 10:01, Brian Fries <iphonzie@gmail.com> =wrote:---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list talk@webdna.usTo unsubscribe, E-mail to: talk-leave@webdna.usarchives: http://www.webdna.us/page.dna?numero=3D55Bug Reporting: support@webdna.us[blank] only works with text comparisons, not numeric =comparisons.Because you set ==E2=80=9CIDType=3Dnum=E2=80=9D, WebDNA is converting the comparison =value ([blank}) to a number. Since it is an invalid number, it uses the =value 0.So this =gets interpreted by WebDNA as =E2=80=9CneIDdata=3D0=E2=80=9DIf you instead use ==E2=80=9CneIDdata=3D999999=E2=80=9D or another number you know won=E2=80=99=t be there, then you will see the zero.- Brian FriesOn Dec 19, 2017, at 2:41 PM, Michael Davis <admin@network13.net>= wrote:[writefile file=3Dsorttest.db]ID<tab>name
-2<tab>-2
-1<tab>-1
0<tab>0
1<tab>1
2<tab>2
[/writefile]
[search =db=3Dsorttest.db&neIDdata=3D[blank]&asIDsort=3D1&IDtype=3Dnum]=
=[founditems]
[name]<br>
=[/founditems]
[/search]
DOWNLOAD WEBDNA NOW!
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...