Re: [WebDNA] What Happened To Zero?

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113892
interpreted = N
texte = 1492 --Apple-Mail=_E5059473-14BB-4F9F-89C6-4948F91472DF Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Thanks guys. Makes sense. > On Dec 19, 2017, at 3:09 PM, Stuart Tremain = wrote: >=20 > Thanks for the tech explanation - always good to know for future use. >=20 > Kind regards >=20 > Stuart Tremain > Pharoah Lane Software > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 >=20 >=20 >> On 20 Dec 2017, at 10:01, Brian Fries > wrote: >>=20 >> [blank] only works with text comparisons, not numeric comparisons. >>=20 >> 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. >>=20 >> So this gets interpreted by WebDNA as =E2=80=9CneIDdata=3D0=E2=80=9D >>=20 >> If 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. >>=20 >> - Brian Fries >>=20 >>> 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 >>=20 >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list = talk@webdna.us To unsubscribe, E-mail to: = talk-leave@webdna.us archives: = http://www.webdna.us/page.dna?numero=3D55 = Bug Reporting: = support@webdna.us > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list = talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: = http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: = support@webdna.us --Apple-Mail=_E5059473-14BB-4F9F-89C6-4948F91472DF Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Thanks guys.  Makes sense.

On Dec = 19, 2017, at 3:09 PM, Stuart Tremain <webdna@idfk.com.au> = wrote:

Thanks for the tech = explanation - always good to know for future use.

Kind regards

Stuart Tremain
Pharoah Lane = Software
AUSTRALIA
webdna@idfk.com.au






On 20 Dec 2017, at 10:01, Brian Fries <iphonzie@gmail.com> = wrote:

[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

On 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]


--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us

= --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --Apple-Mail=_E5059473-14BB-4F9F-89C6-4948F91472DF-- . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] What Happened To Zero? (Brian Harrington 2017)
  2. Re: [WebDNA] What Happened To Zero? (Michael Davis 2017)
  3. Re: [WebDNA] What Happened To Zero? (Stuart Tremain 2017)
  4. Re: [WebDNA] What Happened To Zero? (Stuart Tremain 2017)
  5. Re: [WebDNA] What Happened To Zero? (Brian Fries 2017)
  6. [WebDNA] What Happened To Zero? (Michael Davis 2017)
1492 --Apple-Mail=_E5059473-14BB-4F9F-89C6-4948F91472DF Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Thanks guys. Makes sense. > On Dec 19, 2017, at 3:09 PM, Stuart Tremain = wrote: >=20 > Thanks for the tech explanation - always good to know for future use. >=20 > Kind regards >=20 > Stuart Tremain > Pharoah Lane Software > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 >=20 >=20 >> On 20 Dec 2017, at 10:01, Brian Fries > wrote: >>=20 >> [blank] only works with text comparisons, not numeric comparisons. >>=20 >> 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. >>=20 >> So this gets interpreted by WebDNA as =E2=80=9CneIDdata=3D0=E2=80=9D >>=20 >> If 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. >>=20 >> - Brian Fries >>=20 >>> 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 >>=20 >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list = talk@webdna.us To unsubscribe, E-mail to: = talk-leave@webdna.us archives: = http://www.webdna.us/page.dna?numero=3D55 = Bug Reporting: = support@webdna.us > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list = talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: = http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: = support@webdna.us --Apple-Mail=_E5059473-14BB-4F9F-89C6-4948F91472DF Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Thanks guys.  Makes sense.

On Dec = 19, 2017, at 3:09 PM, Stuart Tremain <webdna@idfk.com.au> = wrote:

Thanks for the tech = explanation - always good to know for future use.

Kind regards

Stuart Tremain
Pharoah Lane = Software
AUSTRALIA
webdna@idfk.com.au






On 20 Dec 2017, at 10:01, Brian Fries <iphonzie@gmail.com> = wrote:

[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

On 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]


--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us

= --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --Apple-Mail=_E5059473-14BB-4F9F-89C6-4948F91472DF-- . Michael Davis

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:

2.0 Info (1997) Can you do this??? and other stuff (1997) RE: type 2 errors with ssl server (1997) WebCat2b13MacPlugIn - more [date] problems (1997) Re:Emailer and encryption (1997) WebCatalog Hosting (1996) WebCat2 several catalogs? (1997) Re1000001: Setting up shop (1997) 2nd WebCatalog2 Feature Request (1996) One Hour Email (2002) New command suggestion (was Modifying databasesmanually) (1997) pictures / referrer etc. (1998) Emailer setup (1997) Opinion: [input] should be called [output] ... (1997) Emailer tracking (1997) Problem with [CART] number (1998) vs (1997) [WebDNA] GETCHARS ... words? (2009) Me know logical no need (2002) Convert Chars Q (2000)