Re: [WebDNA] What Happened To Zero?
This WebDNA talk-list message is from 2017
It keeps the original formatting.
numero = 113889
interpreted = N
texte = 1489--Apple-Mail=_17EDB029-6C61-4D94-A9DF-D37859E224FFContent-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=utf-8[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=99t be there, then you will see the zero.- Brian Fries> On Dec 19, 2017, at 2:41 PM, Michael Davis
=wrote:>=20> [writefile file=3Dsorttest.db]IDname> -2-2> -1-1> 00> 11> 22> [/writefile]>=20> [search db=3Dsorttest.db&neIDdata=3D[blank]&asIDsort=3D1&IDtype=3Dnum]> [founditems]> [name]
> [/founditems]> [/search]>=20--Apple-Mail=_17EDB029-6C61-4D94-A9DF-D37859E224FFContent-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=utf-8[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=9D
If 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 Fries
[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]
=---------------------------------------------------------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--Apple-Mail=_17EDB029-6C61-4D94-A9DF-D37859E224FF--.
Associated Messages, from the most recent to the oldest:
1489--Apple-Mail=_17EDB029-6C61-4D94-A9DF-D37859E224FFContent-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=utf-8[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=99t be there, then you will see the zero.- Brian Fries> On Dec 19, 2017, at 2:41 PM, Michael Davis =wrote:>=20> [writefile file=3Dsorttest.db]IDname> -2-2> -1-1> 00> 11> 22> [/writefile]>=20> [search db=3Dsorttest.db&neIDdata=3D[blank]&asIDsort=3D1&IDtype=3Dnum]> [founditems]> [name]
> [/founditems]> [/search]>=20--Apple-Mail=_17EDB029-6C61-4D94-A9DF-D37859E224FFContent-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=utf-8[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=9D
If 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 Fries
[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]
=---------------------------------------------------------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--Apple-Mail=_17EDB029-6C61-4D94-A9DF-D37859E224FF--.
Brian Fries
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:
Stopping a [Loop] in mid-stream ... (1997)
Uploading out of FMP (2001)
How true is this? (1999)
Password Generator (2004)
Files not moved to EmailCompleted (2002)
unable to launch acgi in WebCat (1997)
WebCat Error Log problem (2.0.1, acgi, Mac) (1997)
back button loses cart (2000)
[WebDNA] Hmmm ... (2008)
Showing formatted results in tables (2002)
Sendmail & Time Issue (2001)
carriage returns in data (1997)
Problems with webcat 2.01 for NT (1997)
Trouble with formula.db (1997)
[referrer] tag (1997)
building / customizing stores (2000)
Permission Denied Error (2001)
Extended [ConvertChars] (1997)
WebCat2b13MacPlugIn - syntax to convert date (1997)
Retrieve deleted files (2001)