Re: [WebDNA] Search using CL

This WebDNA talk-list message is from

2017

It keeps the original formatting. numero = 113568
interpreted = N
texte = 1163--Apple-Mail=_88B06C84-3B31-482C-8251-F56BC3FACF37Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=utf-8But .5 is less than 1 and the search should have produced results =between 1 & 3.Kind regardsStuart TremainPharoah Lane SoftwareAUSTRALIAwebdna@idfk.com.au> On 20 Apr 2017, at 13:56, Donovan Brooke wrote:>=20> Glad you got it sorted.=20>=20> .5 is numerically within 1 digit of 2, so it makes sense to me. If you =were delivering pizzas to zip codes close to a central zip, you'd leave =out some hungry customers if you only delivered to the greater zip =codes.>=20> D. Brooke Mobile>=20> On Apr 19, 2017, at 10:49 PM, Stuart Tremain > wrote:>=20>> Thanks for the proof Donovan .>>=20>> OK, I have it working now, I re-keyed the search, maybe there was a =typo I missed.>>=20>> I did find that this: clGRADEdata=3D2&clGRADEdata=3D1&GRADEtype=3Dnum>>=20>> produced results with .5 in it>>=20>> 1>> 2>> 1>> 2>> .5>> .5>> 1>> .5>> .5>> .5>> .5>> .5>> 1>> 1>> 1>> 1>> 1>> 3>>=20>> .5 is less than 1 so it should not appear.>>=20>>=20>>=20>>=20>>=20>>=20>> Kind regards>>=20>> Stuart Tremain>> Pharoah Lane Software>> AUSTRALIA>> webdna@idfk.com.au >>=20>>=20>>=20>>=20>>=20>>=20>>> On 20 Apr 2017, at 13:25, Donovan Brooke > wrote:>>>=20>>> If you are seeing different results, maybe post your code (with =[product] [platform] and [version].. something similar to what I did.>>>=20>>> Donovan>>>=20>>>=20>>>=20>>> On Apr 19, 2017, at 10:20 PM, Stuart Tremain > wrote:>>>=20>>>> Mmmm, thanks, I think =E2=80=A6=E2=80=A6>>>>=20>>>>=20>>>>=20>>>> Kind regards>>>>=20>>>> Stuart Tremain>>>> Pharoah Lane Software>>>> AUSTRALIA>>>> webdna@idfk.com.au >>>>=20>>>>=20>>>>=20>>>>=20>>>>=20>>>>=20>>>>> On 20 Apr 2017, at 13:16, Donovan Brooke > wrote:>>>>>=20>>>>> Works here:>>>>> http://www.euca.us/admin/tests/cl/ =>>>>>=20>>>>>=20>>>>> Donovan>>>>>=20>>>>>=20>>>>>=20>>>>> On Apr 19, 2017, at 9:30 PM, Stuart Tremain > wrote:>>>>>=20>>>>>> I am looking at using the cl comparison in a search but can=E2=80=99=t get it to work properly, the instructions seem a little odd too:>>>>>>=20>>>>>> close to (numeric only). clZipCodedata=3D92069&clZipCodedata=3D10 =finds all records whose ZipCode field is within 10 of 92069 (92059 - =92079)>>>>>>=20>>>>>> Using the above instructions I have a search that produces 0 =results>>>>>> clGRADEdatarq=3D4&clGRADEdatarq=3D1&GRADEtype=3Dnum>>>>>> I would expect that the search would return all rows with grade =3D= 3 or 4 or 5>>>>>>=20>>>>>> This also produces 0 results>>>>>> clGRADEdata=3D4&clGRADEdata=3D1&GRADEtype=3Dnum>>>>>>=20>>>>>>=20>>>>>> This does produce results but only when the GRADE =3D 4>>>>>> clGRADEdata=3D4>>>>>>=20>>>>>> Any ideas ?>>>>>>=20>>>>>>=20>>>>>>=20>>>>>>=20>>>>>> WebDNA Server version 6.2>>>>>>=20>>>>>>=20>>>>>> Kind regards>>>>>>=20>>>>>> Stuart Tremain>>>>>> Pharoah Lane Software>>>>>> AUSTRALIA>>>>>> webdna@idfk.com.au >>>>>>=20>>>>>>=20>>>>>>=20>>>>>>=20>>>>>>=20>>>>>>=20>>>>>> --------------------------------------------------------- This =message is sent to you because you are subscribed to the mailing list . =To unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: =support@webdna.us >>>>>=20>>>>> --------------------------------------------------------->>>>> This message is sent to you because you are subscribed to>>>>> the mailing list >.>>>>> To unsubscribe, E-mail to: >>>>>> archives: http://mail.webdna.us/list/talk@webdna.us =>>>>> Bug Reporting: support@webdna.us >>>>=20>>>> --------------------------------------------------------- This =message is sent to you because you are subscribed to the mailing list . =To unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: =support@webdna.us >>>=20>>> --------------------------------------------------------->>> This message is sent to you because you are subscribed to>>> the mailing list >.>>> To unsubscribe, E-mail to: >>>> archives: http://mail.webdna.us/list/talk@webdna.us =>>> Bug Reporting: support@webdna.us >>=20>> --------------------------------------------------------- This =message is sent to you because you are subscribed to the mailing list . =To unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: =support@webdna.us =------------------------------------------------=--------- This message is sent to you because you are subscribed to the =mailing list . To unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us Bug Reporting: =support@webdna.us--Apple-Mail=_88B06C84-3B31-482C-8251-F56BC3FACF37Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=utf-8But .5 is less than 1 and the search should have produced =results between 1 & 3.

Kind regards

Stuart Tremain

Pharoah Lane Software

AUSTRALIA

webdna@idfk.com.au

On 20 Apr 2017, at 13:56, Donovan Brooke <dbrooke@euca.us> =wrote:

Glad you got it =sorted.

.5= is numerically within 1 digit of 2, so it makes sense to me. If you =were delivering pizzas to zip codes close to a central zip, you'd leave =out some hungry customers if you only delivered to the greater zip =codes.

D. Brooke Mobile

On Apr 19, 2017, at 10:49 PM, Stuart Tremain =<webdna@idfk.com.au> wrote:

Thanks for the proof Donovan .

OK, I have it working =now, I re-keyed the search, maybe there was a typo I missed.

I did find that this: =clGRADEdata=3D2&clGRADEdata=3D1&GRADEtype=3Dnum

produced results with .5 =in it

1
2
1
2
.5
.5
1
.5
.5
.5
.5
.5
1
1
1
1
1
3

.5= is less than 1 so it should not appear.

Kind regards

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

On 20 Apr 2017, at 13:25, Donovan Brooke <dbrooke@euca.us> =wrote:

If you are seeing different results, maybe post your code =(with [product] [platform] and [version].. something similar to what I =did.

Donovan

On Apr 19, 2017, at 10:20 PM, Stuart Tremain =<webdna@idfk.com.au> wrote:

Mmmm, thanks, I think ==E2=80=A6=E2=80=A6

Kind regards

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

On 20 =Apr 2017, at 13:16, Donovan Brooke <dbrooke@euca.us> wrote:

Works here:
http://www.euca.us/admin/tests/cl/

Donovan

On Apr 19, 2017, at 9:30 PM, Stuart Tremain =<webdna@idfk.com.au> wrote:

I am looking at using =the cl comparison in a search but can=E2=80=99t get it to work properly, =the instructions seem a little odd too:

close= to (numeric only). clZipCodedata=3D92069&clZipCodedata=3D10 finds =all records whose ZipCode field is within 10 of 92069 (92059 - 92079)

Using the above instructions I have a search =that produces 0 results
clGRADEdatarq=3D4&clGRADEdatarq=3D1&GRADEtype=3Dnum
I would expect that the search would return all rows with =grade =3D 3 or 4 or 5

This also produces 0 =results
clGRADEdata=3D4&clGRADEdata=3D1&GRADEtype=3D=num

This does produce =results but only when the GRADE =3D 4
clGRADEdata=3D4

Any ideas ?

WebDNA Server version 6.2

Kind regards

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

--------------------------------------------------------- =This message is sent to you because you are subscribed to the mailing =list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us 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://mail.webdna.us/list/talk@webdna.us
Bug= Reporting: support@webdna.us

--------------------------------------------------------- =This message is sent to you because you are subscribed to the mailing =list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us 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://mail.webdna.us/list/talk@webdna.us
Bug= Reporting: support@webdna.us

---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us
---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us

=---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us--Apple-Mail=_88B06C84-3B31-482C-8251-F56BC3FACF37--. Associated Messages, from the most recent to the oldest:

RE: [WebDNA] Search using CL ("Brian Boegershausen" 2017)
Re: [WebDNA] Search using CL (Brian Boegershausen 2017)
Re: [WebDNA] Search using CL (Terry Wilson 2017)
Re: [WebDNA] Search using CL (Terry Wilson 2017)
Re: [WebDNA] Search using CL (Donovan Brooke 2017)
Re: [WebDNA] Search using CL (Stuart Tremain 2017)
Re: [WebDNA] Search using CL (Donovan Brooke 2017)
Re: [WebDNA] Search using CL (Stuart Tremain 2017)
Re: [WebDNA] Search using CL (Donovan Brooke 2017)
Re: [WebDNA] Search using CL (Stuart Tremain 2017)
Re: [WebDNA] Search using CL (Stuart Tremain 2017)
Re: [WebDNA] Search using CL (Stuart Tremain 2017)
Re: [WebDNA] Search using CL (Donovan Brooke 2017)
Re: [WebDNA] Search using CL (Stuart Tremain 2017)
Re: [WebDNA] Search using CL (Donovan Brooke 2017)
Re: [WebDNA] Search using CL (Terry Wilson 2017)
[WebDNA] Search using CL (Stuart Tremain 2017)

1163--Apple-Mail=_88B06C84-3B31-482C-8251-F56BC3FACF37Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=utf-8But .5 is less than 1 and the search should have produced results =between 1 & 3.Kind regardsStuart TremainPharoah Lane SoftwareAUSTRALIAwebdna@idfk.com.au> On 20 Apr 2017, at 13:56, Donovan Brooke wrote:>=20> Glad you got it sorted.=20>=20> .5 is numerically within 1 digit of 2, so it makes sense to me. If you =were delivering pizzas to zip codes close to a central zip, you'd leave =out some hungry customers if you only delivered to the greater zip =codes.>=20> D. Brooke Mobile>=20> On Apr 19, 2017, at 10:49 PM, Stuart Tremain > wrote:>=20>> Thanks for the proof Donovan .>>=20>> OK, I have it working now, I re-keyed the search, maybe there was a =typo I missed.>>=20>> I did find that this: clGRADEdata=3D2&clGRADEdata=3D1&GRADEtype=3Dnum>>=20>> produced results with .5 in it>>=20>> 1>> 2>> 1>> 2>> .5>> .5>> 1>> .5>> .5>> .5>> .5>> .5>> 1>> 1>> 1>> 1>> 1>> 3>>=20>> .5 is less than 1 so it should not appear.>>=20>>=20>>=20>>=20>>=20>>=20>> Kind regards>>=20>> Stuart Tremain>> Pharoah Lane Software>> AUSTRALIA>> webdna@idfk.com.au >>=20>>=20>>=20>>=20>>=20>>=20>>> On 20 Apr 2017, at 13:25, Donovan Brooke > wrote:>>>=20>>> If you are seeing different results, maybe post your code (with =[product] [platform] and [version].. something similar to what I did.>>>=20>>> Donovan>>>=20>>>=20>>>=20>>> On Apr 19, 2017, at 10:20 PM, Stuart Tremain > wrote:>>>=20>>>> Mmmm, thanks, I think =E2=80=A6=E2=80=A6>>>>=20>>>>=20>>>>=20>>>> Kind regards>>>>=20>>>> Stuart Tremain>>>> Pharoah Lane Software>>>> AUSTRALIA>>>> webdna@idfk.com.au >>>>=20>>>>=20>>>>=20>>>>=20>>>>=20>>>>=20>>>>> On 20 Apr 2017, at 13:16, Donovan Brooke > wrote:>>>>>=20>>>>> Works here:>>>>> http://www.euca.us/admin/tests/cl/ =>>>>>=20>>>>>=20>>>>> Donovan>>>>>=20>>>>>=20>>>>>=20>>>>> On Apr 19, 2017, at 9:30 PM, Stuart Tremain > wrote:>>>>>=20>>>>>> I am looking at using the cl comparison in a search but can=E2=80=99=t get it to work properly, the instructions seem a little odd too:>>>>>>=20>>>>>> close to (numeric only). clZipCodedata=3D92069&clZipCodedata=3D10 =finds all records whose ZipCode field is within 10 of 92069 (92059 - =92079)>>>>>>=20>>>>>> Using the above instructions I have a search that produces 0 =results>>>>>> clGRADEdatarq=3D4&clGRADEdatarq=3D1&GRADEtype=3Dnum>>>>>> I would expect that the search would return all rows with grade =3D= 3 or 4 or 5>>>>>>=20>>>>>> This also produces 0 results>>>>>> clGRADEdata=3D4&clGRADEdata=3D1&GRADEtype=3Dnum>>>>>>=20>>>>>>=20>>>>>> This does produce results but only when the GRADE =3D 4>>>>>> clGRADEdata=3D4>>>>>>=20>>>>>> Any ideas ?>>>>>>=20>>>>>>=20>>>>>>=20>>>>>>=20>>>>>> WebDNA Server version 6.2>>>>>>=20>>>>>>=20>>>>>> Kind regards>>>>>>=20>>>>>> Stuart Tremain>>>>>> Pharoah Lane Software>>>>>> AUSTRALIA>>>>>> webdna@idfk.com.au >>>>>>=20>>>>>>=20>>>>>>=20>>>>>>=20>>>>>>=20>>>>>>=20>>>>>> --------------------------------------------------------- This =message is sent to you because you are subscribed to the mailing list . =To unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: =support@webdna.us >>>>>=20>>>>> --------------------------------------------------------->>>>> This message is sent to you because you are subscribed to>>>>> the mailing list >.>>>>> To unsubscribe, E-mail to: >>>>>> archives: http://mail.webdna.us/list/talk@webdna.us =>>>>> Bug Reporting: support@webdna.us >>>>=20>>>> --------------------------------------------------------- This =message is sent to you because you are subscribed to the mailing list . =To unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: =support@webdna.us >>>=20>>> --------------------------------------------------------->>> This message is sent to you because you are subscribed to>>> the mailing list >.>>> To unsubscribe, E-mail to: >>>> archives: http://mail.webdna.us/list/talk@webdna.us =>>> Bug Reporting: support@webdna.us >>=20>> --------------------------------------------------------- This =message is sent to you because you are subscribed to the mailing list . =To unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us = Bug Reporting: =support@webdna.us =------------------------------------------------=--------- This message is sent to you because you are subscribed to the =mailing list . To unsubscribe, E-mail to: archives: =http://mail.webdna.us/list/talk@webdna.us Bug Reporting: =support@webdna.us--Apple-Mail=_88B06C84-3B31-482C-8251-F56BC3FACF37Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=utf-8But .5 is less than 1 and the search should have produced =results between 1 & 3.