Re: [WebDNA] Search using CL

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113567
interpreted = N
texte = 1162 --Apple-Mail-89D260D1-6C46-4351-B7C8-55881B46B1EF Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Glad you got it sorted.=20 ..5 is numerically within 1 digit of 2, so it makes sense to me. If you were d= elivering pizzas to zip codes close to a central zip, you'd leave out some h= ungry customers if you only delivered to the greater zip codes. D. Brooke Mobile > 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=99t g= et it to work properly, the instructions seem a little odd too: >>>>>=20 >>>>> close to (numeric only). clZipCodedata=3D92069&clZipCodedata=3D10 find= s 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 o= r 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 unsubscr= ibe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Repo= rting: 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 i= s sent to you because you are subscribed to the mailing list . To unsubscrib= e, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Report= ing: 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 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 Reporting:= support@webdna.us --Apple-Mail-89D260D1-6C46-4351-B7C8-55881B46B1EF Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Glad you got it sorted. 

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

D. Brooke Mo= bile

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

<= blockquote type=3D"cite">
Thanks for the proof Donovan .

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

<= div class=3D"">I did find that this: clGRADEdata=3D2&clGRADEdata=3D1&= ;GRADEtype=3Dnum

p= roduced results with .5 in it

1
2
1<= br style=3D"font-family: -webkit-standard;" class=3D"">2
.5
.5
1
.5
.5
.5
.5
.5
1
1
1
1
1=
3

.5 is less than 1 so i= t should not appear.






Kind regards

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


<= br class=3D"Apple-interchange-newline">



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

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

Donovan
<= br class=3D"">

On Apr 19, 2017, at 10:20 PM, St= uart Tremain <webdna@idf= k.com.au> wrote:

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



Kind regards

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






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

Works here:=
http://www.euc= a.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 ca= n=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 o= f 92069 (92059 - 92079)

Using the above instruc= tions I have a search that produces 0 results
clGRADEdatarq=3D= 4&clGRADEdatarq=3D1&GRADEtype=3Dnum
I would expect tha= t the search would return all rows with grade =3D 3 or 4 or 5
=
This also produces 0 results
clGRADEdata=3D4&am= p;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 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.u= s

----------------------------= -----------------------------
This message is sent to you beca= use you are subscribed to
the mailing list <talk@webdna.us>.
To unsubscribe, E-m= ail to: <talk-leave@webdna.us= >
archives: http://mail.webdna.us/list/talk@webdna.us
Bug Repor= ting: support@webdna.us

---------------------------------------------= ------------ This message is sent to you because you are subscribed to the m= ailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us B= ug Reporting: support@webdna.us

--------------------------------------= -------------------
This message is sent to you because you ar= e subscribed to
the mailing list <talk@webdna.us>.
To unsubscribe, E-= mail to: <talk-leave@w= ebdna.us>
archives: http://mail.webdna.us/list/talk@webdna.us<= br class=3D"">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-89D260D1-6C46-4351-B7C8-55881B46B1EF-- . 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)
1162 --Apple-Mail-89D260D1-6C46-4351-B7C8-55881B46B1EF Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Glad you got it sorted.=20 ..5 is numerically within 1 digit of 2, so it makes sense to me. If you were d= elivering pizzas to zip codes close to a central zip, you'd leave out some h= ungry customers if you only delivered to the greater zip codes. D. Brooke Mobile > 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=99t g= et it to work properly, the instructions seem a little odd too: >>>>>=20 >>>>> close to (numeric only). clZipCodedata=3D92069&clZipCodedata=3D10 find= s 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 o= r 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 unsubscr= ibe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Repo= rting: 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 i= s sent to you because you are subscribed to the mailing list . To unsubscrib= e, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Report= ing: 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 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 Reporting:= support@webdna.us --Apple-Mail-89D260D1-6C46-4351-B7C8-55881B46B1EF Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Glad you got it sorted. 

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

D. Brooke Mo= bile

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

<= blockquote type=3D"cite">
Thanks for the proof Donovan .

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

<= div class=3D"">I did find that this: clGRADEdata=3D2&clGRADEdata=3D1&= ;GRADEtype=3Dnum

p= roduced results with .5 in it

1
2
1<= br style=3D"font-family: -webkit-standard;" class=3D"">2
.5
.5
1
.5
.5
.5
.5
.5
1
1
1
1
1=
3

.5 is less than 1 so i= t should not appear.






Kind regards

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


<= br class=3D"Apple-interchange-newline">



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

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

Donovan
<= br class=3D"">

On Apr 19, 2017, at 10:20 PM, St= uart Tremain <webdna@idf= k.com.au> wrote:

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



Kind regards

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






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

Works here:=
http://www.euc= a.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 ca= n=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 o= f 92069 (92059 - 92079)

Using the above instruc= tions I have a search that produces 0 results
clGRADEdatarq=3D= 4&clGRADEdatarq=3D1&GRADEtype=3Dnum
I would expect tha= t the search would return all rows with grade =3D 3 or 4 or 5
=
This also produces 0 results
clGRADEdata=3D4&am= p;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 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.u= s

----------------------------= -----------------------------
This message is sent to you beca= use you are subscribed to
the mailing list <talk@webdna.us>.
To unsubscribe, E-m= ail to: <talk-leave@webdna.us= >
archives: http://mail.webdna.us/list/talk@webdna.us
Bug Repor= ting: support@webdna.us

---------------------------------------------= ------------ This message is sent to you because you are subscribed to the m= ailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us B= ug Reporting: support@webdna.us

--------------------------------------= -------------------
This message is sent to you because you ar= e subscribed to
the mailing list <talk@webdna.us>.
To unsubscribe, E-= mail to: <talk-leave@w= ebdna.us>
archives: http://mail.webdna.us/list/talk@webdna.us<= br class=3D"">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-89D260D1-6C46-4351-B7C8-55881B46B1EF-- . Donovan Brooke

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:

Explorer 3.0/ Access Denied! (1997) RE: Template not found error messages (1997) Discounts: Buy One, Get One =?ISO-8859-1?Q?99=A2?= (2004) Popup Menu Options (1998) [searchString] (1997) Cookie setting (2003) Trouble with formula.db (1997) Summing fields (1997) Not really WebCat (1997) Security (1998) Country & Ship-to address & other fields ? (1997) DON'T use old cart file! (1997) What file? (1997) all records returned. (1997) [WebDNA] WebDNA crash and now emailer not working (2009) using [URL] in search parameters? (1999) Country & Ship-to address & other fields ? (1997) shipping help (1998) Error Lob.db records error message not name (1997) default value from Lookup (was Grant, please help me) (1997)