Re: [WebDNA] Search using CL

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113576
interpreted = N
texte = 1171 ------=_Part_1572_1743726625.1492690810737 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I used to have a great zipcode search db and code example that uses radius = and the long/lat of the searched zipcode. Let me see if i can dig that up today. Brian Get Outlook for Android On Thu, Apr 20, 2017 at 1:08 AM -0400, "Terry Wilson" = wrote: BTW zip codes aren=E2=80=99t numbered according to location; they are assig= ned alphabetically, within the 3 digit region. Check a list of your own are= a=E2=80=99s zip codes, sorted by city alphabetically, and you=E2=80=99ll se= e the correlation. So, 12301 and 12302 could be on opposite ends of the reg= ion, while 12399 could be right next door to 12301. The number value has no= thing to do with its location relative to one another. On Apr 19, 2017, at 8:56 PM, Donovan Brooke wrote: Glad you got it sorted.=C2=A0 ..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 som= e hungry customers if you only delivered to the greater zip codes. D. Brooke Mobile On Apr 19, 2017, at 10:49 PM, Stuart Tremain 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 TremainPharoah Lane SoftwareAUSTRALIAwebdna@idfk.com.au On 20 Apr 2017, at 13:25, Donovan Brooke 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 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 wrote: Works here: http://www.euca.us/admin/tests/cl/ Donovan On Apr 19, 2017, at 9:30 PM, Stuart Tremain wrote: I am looking at using the cl comparison in a search but can=E2=80=99t get i= t 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=3Dnum 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 s= ent 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 Reporti= ng: 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 s= ent 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 Reporti= ng: 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:=20 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:=20 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:=20 archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us ------=_Part_1572_1743726625.1492690810737 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable

I used to have a great zipcode sear= ch db and code example that uses radius and the long/lat of the searched zi= pcode.

Let me see if i can dig that up today.

Brian

Get Outlook for Android





On Thu, Apr 20, 2017 at 1:08 AM -0400, "Terry Wi= lson" <terry@terryfic.com> wrote:

BTW zip codes aren=E2=80=99t numbered according to location; t= hey 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 e= nds of the region, while 12399 could be right next door to 12301. The numbe= r value has nothing to do with its location relative to one another.
<= div class=3D"">

On Apr 19, 2017, at 8:56 PM, Donovan Brooke &l= t;dbrooke@euca.us> wro= te:

<= div dir=3D"auto" class=3D"">
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
<= br class=3D"">
Stuart Tremain
Pha= roah 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 [ve= rsion].. something similar to what I did.

Dono= van



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

<= blockquote type=3D"cite" class=3D"">Mmmm, thanks, I think =E2=80=A6=E2=80= =A6



Kind regards=

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






On 20 Apr 2017, at 13:16, Donovan Brooke &l= t;dbrooke@euca.us> wro= te:

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


Donovan


On Apr 19, 2017, at 9:30 PM, Stua= rt 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=3D9206= 9&clZipCodedata=3D10 finds all records whose ZipCode field is within 10= of 92069 (92059 - 92079)

Using the above inst= ructions I have a search that produces 0 results
clGRADEdatar= q=3D4&clGRADEdatarq=3D1&GRADEtype=3Dnum
I would expec= t 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=3Dnum

<= br class=3D"">This does produce results but only when the GRADE =3D 4
clGRADEdata=3D4

Any ideas ?




WebDNA Se= rver version 6.2


Kind regards
Stuart Tremain
Pharoah Lane Softw= are
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 subs= cribed to
the mailing list <talk@webdna.us>.
To unsubscribe, E-mail= to: <talk-leave@webd= na.us>
archives: http://mail.webdna.us/list/talk@webdna.usBug 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 subscribe= d 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: supp= ort@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@webd= na.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@webd= na.us
<= br class=3D""> --------------------------------------------------------- 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 ------=_Part_1572_1743726625.1492690810737-- . 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)
1171 ------=_Part_1572_1743726625.1492690810737 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I used to have a great zipcode search db and code example that uses radius = and the long/lat of the searched zipcode. Let me see if i can dig that up today. Brian Get Outlook for Android On Thu, Apr 20, 2017 at 1:08 AM -0400, "Terry Wilson" = wrote: BTW zip codes aren=E2=80=99t numbered according to location; they are assig= ned alphabetically, within the 3 digit region. Check a list of your own are= a=E2=80=99s zip codes, sorted by city alphabetically, and you=E2=80=99ll se= e the correlation. So, 12301 and 12302 could be on opposite ends of the reg= ion, while 12399 could be right next door to 12301. The number value has no= thing to do with its location relative to one another. On Apr 19, 2017, at 8:56 PM, Donovan Brooke wrote: Glad you got it sorted.=C2=A0 ..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 som= e hungry customers if you only delivered to the greater zip codes. D. Brooke Mobile On Apr 19, 2017, at 10:49 PM, Stuart Tremain 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 TremainPharoah Lane SoftwareAUSTRALIAwebdna@idfk.com.au On 20 Apr 2017, at 13:25, Donovan Brooke 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 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 wrote: Works here: http://www.euca.us/admin/tests/cl/ Donovan On Apr 19, 2017, at 9:30 PM, Stuart Tremain wrote: I am looking at using the cl comparison in a search but can=E2=80=99t get i= t 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=3Dnum 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 s= ent 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 Reporti= ng: 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 s= ent 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 Reporti= ng: 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:=20 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:=20 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:=20 archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us ------=_Part_1572_1743726625.1492690810737 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable

I used to have a great zipcode sear= ch db and code example that uses radius and the long/lat of the searched zi= pcode.

Let me see if i can dig that up today.

Brian

Get Outlook for Android





On Thu, Apr 20, 2017 at 1:08 AM -0400, "Terry Wi= lson" <terry@terryfic.com> wrote:

BTW zip codes aren=E2=80=99t numbered according to location; t= hey 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 e= nds of the region, while 12399 could be right next door to 12301. The numbe= r value has nothing to do with its location relative to one another.
<= div class=3D"">

On Apr 19, 2017, at 8:56 PM, Donovan Brooke &l= t;dbrooke@euca.us> wro= te:

<= div dir=3D"auto" class=3D"">
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
<= br class=3D"">
Stuart Tremain
Pha= roah 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 [ve= rsion].. something similar to what I did.

Dono= van



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

<= blockquote type=3D"cite" class=3D"">Mmmm, thanks, I think =E2=80=A6=E2=80= =A6



Kind regards=

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






On 20 Apr 2017, at 13:16, Donovan Brooke &l= t;dbrooke@euca.us> wro= te:

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


Donovan


On Apr 19, 2017, at 9:30 PM, Stua= rt 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=3D9206= 9&clZipCodedata=3D10 finds all records whose ZipCode field is within 10= of 92069 (92059 - 92079)

Using the above inst= ructions I have a search that produces 0 results
clGRADEdatar= q=3D4&clGRADEdatarq=3D1&GRADEtype=3Dnum
I would expec= t 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=3Dnum

<= br class=3D"">This does produce results but only when the GRADE =3D 4
clGRADEdata=3D4

Any ideas ?




WebDNA Se= rver version 6.2


Kind regards
Stuart Tremain
Pharoah Lane Softw= are
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 subs= cribed to
the mailing list <talk@webdna.us>.
To unsubscribe, E-mail= to: <talk-leave@webd= na.us>
archives: http://mail.webdna.us/list/talk@webdna.usBug 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 subscribe= d 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: supp= ort@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@webd= na.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@webd= na.us<= br class=3D""> --------------------------------------------------------- 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 ------=_Part_1572_1743726625.1492690810737-- . Brian Boegershausen

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:

math on date? (1997) Serial Number Question (1997) Crashes and prior posting (2006) Stumped (1999) page chokes on hideif when false and ignored (1998) Price Hacking (1998) Large founditems loops (2000) Help! WebCat2 bug (1997) Hard Questions ? (1997) Removing [showif] makes a big difference in speed (1997) PCS Frames (1997) WebStar and CopyFile (2000) WebDNA 5.0 and Mac OS/9 ... The facts (2003) WebCat2b15MacPlugin - [protect] (1997) Where is f2? (1997) Running 2 two WebCatalog.acgi's (1996) Slightly OT: Regex and Date Modified/Created (2002) WebCat2: Items xx to xx shown, etc. (1997) multi-paragraph fields (1997) [no_cache]?! (2000)