Re: [WebDNA] What Happened To Zero?

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113891
interpreted = N
texte = 1491 --Apple-Mail=_686EB42A-EE87-4D7E-89FB-EF5224961BD9 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 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 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 --Apple-Mail=_686EB42A-EE87-4D7E-89FB-EF5224961BD9 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Thanks for the tech explanation - always good to know for = future use.

Kind regards

Stuart Tremain
Pharoah Lane Software
AUSTRALIA






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 --Apple-Mail=_686EB42A-EE87-4D7E-89FB-EF5224961BD9-- . 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)
1491 --Apple-Mail=_686EB42A-EE87-4D7E-89FB-EF5224961BD9 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 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 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 --Apple-Mail=_686EB42A-EE87-4D7E-89FB-EF5224961BD9 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Thanks for the tech explanation - always good to know for = future use.

Kind regards

Stuart Tremain
Pharoah Lane Software
AUSTRALIA






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 --Apple-Mail=_686EB42A-EE87-4D7E-89FB-EF5224961BD9-- . Stuart Tremain

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:

Extended [ConvertChars] (1997) Bug Report, maybe (1997) default value from Lookup (was Grant, please help me) (1997) Exclamation point (1997) Security Issue (1999) t or f (1997) Serving images from databases (1998) Webcat2, WebCommerce, Mod 10 etc. (1997) [showif]/[hideif] question (1997) Emailer help....! (1997) WebCatalog2 Feature Feedback (1996) Frames and WebCat (1997) taxTotal problem (1998) Webcat and logging (1998) WebCommerce: Folder organization ? (1997) WebMerchant (1997) Free Utility (2003) [OT] What log analyzer do you use? (2000) Only charge card when product shipped ? (1997) Math with Time (1997)