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:

WebCat2b15MacPlugin - [protect] (1997) Menu Madness (2001) [WebDNA] SEARCH question - SHOWIF - HIDEIF question (2011) Editing the search string (1997) Preserving form data (1999) Full text search (1999) [WebDNA] To be or not to be friendly (URLs) (2011) Wanted: Broader string manipulation functions (1997) Formating found categories (1997) RE: WebDNA-Talk searchable? (1997) Mac Vs WindowsNT (1997) Gremlins, huh? (2000) Search all Fields in a db (1997) PageMaker/Quark to db (1999) AuthorizeNet & StoreBuilder (2002) Passing Variables to a [shell scriptid=123][/shell] context (2004) Sku numbers (1997) Fwd: HTML encoding in URLs (1997) ssl/empty cart problem (2003) Ampersand in XHTML Code - Not Valid (2005)