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:

RE: Signal Raised (1997) RE: Discounting prices across a site (1997) Check Boxes (2000) WCS Newbie question (1997) How to add product size choices to form? (1997) Can this be done? (1997) Bug Report, maybe (1997) WebMerchant 1.6 and SHTML (1997) authenticate and password (1998) Submit buttons not working.... (1999) WebDNA Writer Needed (1997) Botched cart numbers in webmerchant 2.1x email with webcat 3 (1998) Almost a there but..bye bye NetCloak (1997) RE: Emailer on NT! (1998) Automatically submitting form with web cat. (2001) A question about security (1998) Renaming DB fields (2000) Make sure I understand this??? (1997) [WebDNA] [listwords] and [index] (2009) ShowCart (2001)