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:

Some Questions (1997) ShopsOnTheNet - How many are using WebCat? (1999) File dates in WebCatalog .tmpl/.inc (1997) Username/Password with [Protect] (2000) price on detail, but not shoppingcart (1997) Applescript in Webcatalog problem (1997) WebCat2b12--[searchstring] bug (1997) extending webcatalog (1997) WebCat.acgi from /cgi-bin/? (1997) [Sum] function? (1997) Converting characters to numbers ... (1997) Printing controls - form feeds (2002) RE: protect tag on NT (1997) relogin same user? (1998) EMailFolder vs. EMailCompleted folder (2002) AppleScript: Tell application:app location? (1998) HELP WITH DATES (1997) [WebDNA] 3-5 GB of native WebDNA db in RAM?, else MySQL w/WebDNA [SQL] tags, else skip WebDNA altogether? (2009) TCPSend/Replace DB Records (2002) incrementing a counter remotely? (1999)