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:

Nested search (1997) Word Breaks (1998) restart needed???? (1997) WebCat Documentation (was [platform] tag?) (1998) Protect and Serve (1999) [cart] not being interpreted inside [founditems] (1997) New Command prefs ... (1997) os 8.5 (1999) WebCatalog Eating 200% of the CPU (2002) OT: Processor Speed (2002) ConvertChars request (1999) WebCatalog for guestbook ? (1997) Problem with 2.1b3 (1997) Fields/Forms Processing (1998) QuickBooks Import? (2007) Multiple Ad databases? (1997) New commands in Final candidate (1997) Been meaning to ask... (1997) PCS Frames (1997) WebDNA Codes in Secure Mode (1997)