Re: [WebDNA] Search using CL

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113571
interpreted = N
texte = 1166 --Apple-Mail-4899F0A3-955A-4761-87B3-B0F041B11065 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable I wonder if 3.5 would be returned as well. D. Brooke Mobile > On Apr 19, 2017, at 11:35 PM, Donovan Brooke wrote: >=20 > Oh, right, your start is 2. That is odd.=20 >=20 > D. Brooke Mobile >=20 >> On Apr 19, 2017, at 11:30 PM, Stuart Tremain wrote: >>=20 >> But .5 is less than 1 and the search should have produced results between= 1 & 3. >>=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: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 w= ere delivering pizzas to zip codes close to a central zip, you'd leave out s= ome 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 typ= o 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 [produ= ct] [platform] and [version].. something similar to what I did. >>>>>=20 >>>>> Donovan >>>>>=20 >>>>>=20 >>>>>=20 >>>>>> On Apr 19, 2017, at 10:20 PM, Stuart Tremain wro= te: >>>>>>=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 wr= ote: >>>>>>>>=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 f= inds all records whose ZipCode field is within 10 of 92069 (92059 - 92079) >>>>>>>>=20 >>>>>>>> Using the above instructions I have a search that produces 0 result= s >>>>>>>> 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 mess= age is sent to you because you are subscribed to the mailing list . To unsub= scribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug R= eporting: 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 messag= e is sent to you because you are subscribed to the mailing list . To unsubsc= ribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Rep= orting: 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 >>> --------------------------------------------------------- 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 Reporti= ng: 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 Reporting:= support@webdna.us --Apple-Mail-4899F0A3-955A-4761-87B3-B0F041B11065 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
I wonder if 3.5 would be returned as w= ell.

D. Brooke Mobile

On Apr 19, 2017, at 11:35 PM, Don= ovan Brooke <dbrooke@euca.us> w= rote:

Oh, right, your start is= 2. That is odd. 

D. Brooke Mobile

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

But .5= is less than 1 and the search should have produced results between 1 & 3= ..


Kind regards

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





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

Glad you got it sorted. 

<= div class=3D"">.5 is numerically within 1 digit of 2, so it makes sense to m= e. If you were delivering pizzas to zip codes close to a central zip, you'd l= eave out some hungry customers if you only delivered to the greater zip code= s.

D. Brooke Mobile

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

Thanks for the proof Donovan .

<= div class=3D"">OK, I have it working now, I re-keyed the search, maybe there= was a typo I missed.

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

produced results wi= th .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.

<= div class=3D"">




Kind regards

Stua= rt Tremain
Pharoah Lane Software
A= USTRALIA
webdna@idfk.com.au





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

If you are seeing dif= ferent 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:
<= br class=3D"">Works here:
http://www.euca.us/admin/tests/cl/
<= br class=3D"">
Donovan



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

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

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

Using the above instructions I have a search that produ= ces 0 results
clGRADEdatarq=3D4&clGRADEdatarq=3D1&GRAD= Etype=3Dnum
I would expect that the search would return all ro= ws with grade =3D 3 or 4 or 5

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


This does produce results bu= t 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
=




<= br class=3D"">--------------------------------------------------------- This= message is sent to you because you are subscribed to the mailing list . To u= nsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Repo= rting: support@webdna.us=

---------------------------------= ------------------------
This message is sent to you because y= ou are subscribed to
the mailing list <talk@webdna.us>.
To unsubscrib= e, E-mail to: <talk-le= ave@webdna.us>
archives: http://mail.webdna.us/list/talk@webdna.us=
Bug Reporting: support@webdna.us

------= --------------------------------------------------- This message is sent to y= ou because you are subscribed to the mailing list . To unsubscribe, E-mail t= o: 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><= br class=3D"">archives: http://mail.webdna.us/list/talk@webdna.us
Bug= Reporting: support@webdna.u= s

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: h= ttp://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdn= a.us
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: h= ttp://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdn= a.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-4899F0A3-955A-4761-87B3-B0F041B11065-- . 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)
1166 --Apple-Mail-4899F0A3-955A-4761-87B3-B0F041B11065 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable I wonder if 3.5 would be returned as well. D. Brooke Mobile > On Apr 19, 2017, at 11:35 PM, Donovan Brooke wrote: >=20 > Oh, right, your start is 2. That is odd.=20 >=20 > D. Brooke Mobile >=20 >> On Apr 19, 2017, at 11:30 PM, Stuart Tremain wrote: >>=20 >> But .5 is less than 1 and the search should have produced results between= 1 & 3. >>=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: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 w= ere delivering pizzas to zip codes close to a central zip, you'd leave out s= ome 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 typ= o 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 [produ= ct] [platform] and [version].. something similar to what I did. >>>>>=20 >>>>> Donovan >>>>>=20 >>>>>=20 >>>>>=20 >>>>>> On Apr 19, 2017, at 10:20 PM, Stuart Tremain wro= te: >>>>>>=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 wr= ote: >>>>>>>>=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 f= inds all records whose ZipCode field is within 10 of 92069 (92059 - 92079) >>>>>>>>=20 >>>>>>>> Using the above instructions I have a search that produces 0 result= s >>>>>>>> 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 mess= age is sent to you because you are subscribed to the mailing list . To unsub= scribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug R= eporting: 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 messag= e is sent to you because you are subscribed to the mailing list . To unsubsc= ribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Rep= orting: 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 >>> --------------------------------------------------------- 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 Reporti= ng: 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 Reporting:= support@webdna.us --Apple-Mail-4899F0A3-955A-4761-87B3-B0F041B11065 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
I wonder if 3.5 would be returned as w= ell.

D. Brooke Mobile

On Apr 19, 2017, at 11:35 PM, Don= ovan Brooke <dbrooke@euca.us> w= rote:

Oh, right, your start is= 2. That is odd. 

D. Brooke Mobile

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

But .5= is less than 1 and the search should have produced results between 1 & 3= ..


Kind regards

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





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

Glad you got it sorted. 

<= div class=3D"">.5 is numerically within 1 digit of 2, so it makes sense to m= e. If you were delivering pizzas to zip codes close to a central zip, you'd l= eave out some hungry customers if you only delivered to the greater zip code= s.

D. Brooke Mobile

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

Thanks for the proof Donovan .

<= div class=3D"">OK, I have it working now, I re-keyed the search, maybe there= was a typo I missed.

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

produced results wi= th .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.

<= div class=3D"">




Kind regards

Stua= rt Tremain
Pharoah Lane Software
A= USTRALIA
webdna@idfk.com.au





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

If you are seeing dif= ferent 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:
<= br class=3D"">Works here:
http://www.euca.us/admin/tests/cl/
<= br class=3D"">
Donovan



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

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

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

Using the above instructions I have a search that produ= ces 0 results
clGRADEdatarq=3D4&clGRADEdatarq=3D1&GRAD= Etype=3Dnum
I would expect that the search would return all ro= ws with grade =3D 3 or 4 or 5

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


This does produce results bu= t 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
=




<= br class=3D"">--------------------------------------------------------- This= message is sent to you because you are subscribed to the mailing list . To u= nsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Repo= rting: support@webdna.us=

---------------------------------= ------------------------
This message is sent to you because y= ou are subscribed to
the mailing list <talk@webdna.us>.
To unsubscrib= e, E-mail to: <talk-le= ave@webdna.us>
archives: http://mail.webdna.us/list/talk@webdna.us=
Bug Reporting: support@webdna.us

------= --------------------------------------------------- This message is sent to y= ou because you are subscribed to the mailing list . To unsubscribe, E-mail t= o: 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><= br class=3D"">archives: http://mail.webdna.us/list/talk@webdna.us
Bug= Reporting: support@webdna.u= s

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: h= ttp://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdn= a.us
--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: h= ttp://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdn= a.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-4899F0A3-955A-4761-87B3-B0F041B11065-- . 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:

[format xs] freeze (1997) PCS Frames (1997) Smith Micro - no competition (2000) Stumpted Again (1997) db extesion (2000) WebCommerce: Folder organization ? (1997) New WebCatalog Version !!! (1997) Webcat & SIMS (1998) [WebDNA] WebDNA and macOS 10.4 Mojave - Operational? (2018) Hiding words (2000) RE: PIXO support (1997) I got caught! (2003) [Webcat 2]Next (1997) [WebDNA] How to code a 301 redirect (2008) Not really WebCat (1997) if else problem (2003) Format question WC Mac f3 (1997) Upload images to non DNA server (2004) SQLCONNECT (2005) displaying New products (using [date]) (1997)