Re: [WebDNA] Search using CL

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113559
interpreted = N
texte = 1154 --Apple-Mail=_A63209E2-416F-4864-A614-9EC02012DC8F Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 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 = 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 --Apple-Mail=_A63209E2-416F-4864-A614-9EC02012DC8F Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 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 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=_A63209E2-416F-4864-A614-9EC02012DC8F-- . 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)
1154 --Apple-Mail=_A63209E2-416F-4864-A614-9EC02012DC8F Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 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 = 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 --Apple-Mail=_A63209E2-416F-4864-A614-9EC02012DC8F Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 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 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=_A63209E2-416F-4864-A614-9EC02012DC8F-- . Terry Wilson

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:

test (2002) Refering page (1998) Shopping Cart Directory (2000) Emailer setup (1997) tcpconnect/tcpsend frustrations (2002) Re: (2000) WebCat2 - Getting to the browser's username/password data (1997) Bug? (1997) Browser Problem?!? POST forms and NN 4.0+ browsers (1997) Uh...can someone help me out with the b10? (1997) Commitdatabase tag (1998) Local redirects ... (2005) Help with Repost Data msg from form (1997) 2.0Beta Command Ref (can't find this instruction) (1997) Upgrading old WebCat Database Files (1997) E-Mail Preferences in Admin Folder (1997) Looking for a WebCatlog programmer in the Silicon Valley (1998) [WebDNA] Installing WebDNA on Windows 7 64 Bit, Home Premium (2010) [WebDNA] HTML/OS vs. WebDNA ? (2008) Re:Help name our technology! (1997)