Re: [WebDNA] Search using CL

This WebDNA talk-list message is from

2017

It keeps the original formatting. numero = 113564
interpreted = N
texte = 1159--Apple-Mail=_4BAC9344-9CA9-4446-8BAE-37AC442B7509Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=utf-8My thoughts exactly Terry.I have never used =E2=80=98cl=E2=80=99Kind regardsStuart TremainPharoah Lane SoftwareAUSTRALIAwebdna@idfk.com.au> On 20 Apr 2017, at 13:07, Terry Wilson wrote:>=20> This is new to me. It looks like a mistake in the instructions. Both =statements are the same. It would confuse webdna. I=E2=80=99m thinking =like fieldnamefuzziness=3D10 or something similar, along the lines of =fieldnametype or fieldnamewbrk.>=20> Terry>=20>=20>> On Apr 19, 2017, at 7:30 PM, Stuart Tremain > wrote:>>=20>> 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:>>=20>> close to (numeric only). clZipCodedata=3D92069&clZipCodedata=3D10 =finds 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 =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 =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=_4BAC9344-9CA9-4446-8BAE-37AC442B7509Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=utf-8My thoughts exactly Terry.

I have never used =E2=80=98cl=E2=80=99

Kind regards

Stuart Tremain

Pharoah Lane Software

AUSTRALIA

webdna@idfk.com.au

On 20 Apr 2017, at 13:07, Terry Wilson <terry@terryfic.com> =wrote:

This is new to =me. It looks like a mistake in the instructions. Both statements are the =same. It would confuse webdna. I=E2=80=99m thinking like =fieldnamefuzziness=3D10 or something similar, along the lines of =fieldnametype or fieldnamewbrk.

Terry

On Apr 19, 2017, at 7:30 PM, Stuart 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=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

---------------------------------------------------------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

=---------------------------------------------------------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=_4BAC9344-9CA9-4446-8BAE-37AC442B7509--. 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)

1159--Apple-Mail=_4BAC9344-9CA9-4446-8BAE-37AC442B7509Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=utf-8My thoughts exactly Terry.I have never used =E2=80=98cl=E2=80=99Kind regardsStuart TremainPharoah Lane SoftwareAUSTRALIAwebdna@idfk.com.au> On 20 Apr 2017, at 13:07, Terry Wilson wrote:>=20> This is new to me. It looks like a mistake in the instructions. Both =statements are the same. It would confuse webdna. I=E2=80=99m thinking =like fieldnamefuzziness=3D10 or something similar, along the lines of =fieldnametype or fieldnamewbrk.>=20> Terry>=20>=20>> On Apr 19, 2017, at 7:30 PM, Stuart Tremain > wrote:>>=20>> 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:>>=20>> close to (numeric only). clZipCodedata=3D92069&clZipCodedata=3D10 =finds 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 =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 =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=_4BAC9344-9CA9-4446-8BAE-37AC442B7509Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=utf-8My thoughts exactly Terry.