[WebDNA] Search using CL

This WebDNA talk-list message is from

2017

It keeps the original formatting. numero = 113558
interpreted = N
texte = 1153--Apple-Mail=_034ED237-19F2-4AD6-9B66-091E8949C105Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=utf-8I 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=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 resultsclGRADEdatarq=3D4&clGRADEdatarq=3D1&GRADEtype=3DnumI would expect that the search would return all rows with grade =3D 3 or =4 or 5This also produces 0 resultsclGRADEdata=3D4&clGRADEdata=3D1&GRADEtype=3DnumThis does produce results but only when the GRADE =3D 4clGRADEdata=3D4Any ideas ?WebDNA Server version 6.2Kind regardsStuart TremainPharoah Lane SoftwareAUSTRALIAwebdna@idfk.com.au--Apple-Mail=_034ED237-19F2-4AD6-9B66-091E8949C105Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=utf-8I 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=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 sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us--Apple-Mail=_034ED237-19F2-4AD6-9B66-091E8949C105--. Associated Messages, from the most recent to the oldest:

RE: [WebDNA] Search using CL ("Brian Boegershausen" 2017)
Re: [WebDNA] Search using CL (Brian Boegershausen 2017)
Re: [WebDNA] Search using CL (Terry Wilson 2017)
Re: [WebDNA] Search using CL (Terry Wilson 2017)
Re: [WebDNA] Search using CL (Donovan Brooke 2017)
Re: [WebDNA] Search using CL (Stuart Tremain 2017)
Re: [WebDNA] Search using CL (Donovan Brooke 2017)
Re: [WebDNA] Search using CL (Stuart Tremain 2017)
Re: [WebDNA] Search using CL (Donovan Brooke 2017)
Re: [WebDNA] Search using CL (Stuart Tremain 2017)
Re: [WebDNA] Search using CL (Stuart Tremain 2017)
Re: [WebDNA] Search using CL (Stuart Tremain 2017)
Re: [WebDNA] Search using CL (Donovan Brooke 2017)
Re: [WebDNA] Search using CL (Stuart Tremain 2017)
Re: [WebDNA] Search using CL (Donovan Brooke 2017)
Re: [WebDNA] Search using CL (Terry Wilson 2017)
[WebDNA] Search using CL (Stuart Tremain 2017)

1153--Apple-Mail=_034ED237-19F2-4AD6-9B66-091E8949C105Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=utf-8I 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=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 resultsclGRADEdatarq=3D4&clGRADEdatarq=3D1&GRADEtype=3DnumI would expect that the search would return all rows with grade =3D 3 or =4 or 5This also produces 0 resultsclGRADEdata=3D4&clGRADEdata=3D1&GRADEtype=3DnumThis does produce results but only when the GRADE =3D 4clGRADEdata=3D4Any ideas ?WebDNA Server version 6.2Kind regardsStuart TremainPharoah Lane SoftwareAUSTRALIAwebdna@idfk.com.au--Apple-Mail=_034ED237-19F2-4AD6-9B66-091E8949C105Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=utf-8I 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: