Re: [WebDNA] Search using CL

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113573
interpreted = N
texte = 1168 --Apple-Mail=_3EA0E3BA-78C7-43E5-9B49-0AA27428B417 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 BTW zip codes aren=E2=80=99t numbered according to location; they are = assigned alphabetically, within the 3 digit region. Check a list of your = own area=E2=80=99s zip codes, sorted by city alphabetically, and = you=E2=80=99ll see the correlation. So, 12301 and 12302 could be on = opposite ends of the region, while 12399 could be right next door to = 12301. The number value has nothing to do with its location relative to = one another. > On Apr 19, 2017, at 8:56 PM, 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=_3EA0E3BA-78C7-43E5-9B49-0AA27428B417 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
BTW zip codes aren=E2=80=99t numbered = according to location; they are assigned alphabetically, within the 3 = digit region. Check a list of your own area=E2=80=99s zip codes, sorted = by city alphabetically, and you=E2=80=99ll see the correlation. So, = 12301 and 12302 could be on opposite ends of the region, while 12399 = could be right next door to 12301. The number value has nothing to do = with its location relative to one another.

On Apr 19, 2017, at 8:56 PM, 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 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

= --------------------------------------------------------- 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=_3EA0E3BA-78C7-43E5-9B49-0AA27428B417-- . Associated Messages, from the most recent to the oldest:

    
  1. RE: [WebDNA] Search using CL ("Brian Boegershausen" 2017)
  2. Re: [WebDNA] Search using CL (Brian Boegershausen 2017)
  3. Re: [WebDNA] Search using CL (Terry Wilson 2017)
  4. Re: [WebDNA] Search using CL (Terry Wilson 2017)
  5. Re: [WebDNA] Search using CL (Donovan Brooke 2017)
  6. Re: [WebDNA] Search using CL (Stuart Tremain 2017)
  7. Re: [WebDNA] Search using CL (Donovan Brooke 2017)
  8. Re: [WebDNA] Search using CL (Stuart Tremain 2017)
  9. Re: [WebDNA] Search using CL (Donovan Brooke 2017)
  10. Re: [WebDNA] Search using CL (Stuart Tremain 2017)
  11. Re: [WebDNA] Search using CL (Stuart Tremain 2017)
  12. Re: [WebDNA] Search using CL (Stuart Tremain 2017)
  13. Re: [WebDNA] Search using CL (Donovan Brooke 2017)
  14. Re: [WebDNA] Search using CL (Stuart Tremain 2017)
  15. Re: [WebDNA] Search using CL (Donovan Brooke 2017)
  16. Re: [WebDNA] Search using CL (Terry Wilson 2017)
  17. [WebDNA] Search using CL (Stuart Tremain 2017)
1168 --Apple-Mail=_3EA0E3BA-78C7-43E5-9B49-0AA27428B417 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 BTW zip codes aren=E2=80=99t numbered according to location; they are = assigned alphabetically, within the 3 digit region. Check a list of your = own area=E2=80=99s zip codes, sorted by city alphabetically, and = you=E2=80=99ll see the correlation. So, 12301 and 12302 could be on = opposite ends of the region, while 12399 could be right next door to = 12301. The number value has nothing to do with its location relative to = one another. > On Apr 19, 2017, at 8:56 PM, 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=_3EA0E3BA-78C7-43E5-9B49-0AA27428B417 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8
BTW zip codes aren=E2=80=99t numbered = according to location; they are assigned alphabetically, within the 3 = digit region. Check a list of your own area=E2=80=99s zip codes, sorted = by city alphabetically, and you=E2=80=99ll see the correlation. So, = 12301 and 12302 could be on opposite ends of the region, while 12399 = could be right next door to 12301. The number value has nothing to do = with its location relative to one another.

On Apr 19, 2017, at 8:56 PM, 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 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

= --------------------------------------------------------- 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=_3EA0E3BA-78C7-43E5-9B49-0AA27428B417-- . Terry Wilson

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:

WebCat2: Found Items syntax, etc. (1997) Goofy Date Sorting (1998) Summing fields (1997) More on the email templates (1997) WC TableGrinder (1997) autocommit problem (1998) Checkboxes (1998) selecting multiple found items (1997) Emailer again & again (1997) Problems getting parameters passed into email. (1997) Order not created error (never mind) (1997) Aquick question about replace (1999) [OT] Shell script (2004) Return records from another (1997) Strange errors in error log (1998) tcpconnect (1999) Webcat2, WebCommerce, Mod 10 etc. (1997) Discounting prices across a site (1997) Database Helper missing? (2000) Random ads (1998)