Re: [WebDNA] Search using CL

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113566
interpreted = N
texte = 1161 --Apple-Mail=_E1DB274F-1DE8-4606-8B8C-D85F1A50AEC6 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Thanks for the proof Donovan . OK, I have it working now, I re-keyed the search, maybe there was a typo = I missed. I did find that this: clGRADEdata=3D2&clGRADEdata=3D1&GRADEtype=3Dnum produced results with .5 in it 1 2 1 2 ..5 ..5 1 ..5 ..5 ..5 ..5 ..5 1 1 1 1 1 3 ..5 is less than 1 so it should not appear. Kind regards Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@idfk.com.au > On 20 Apr 2017, at 13:25, Donovan Brooke wrote: >=20 > If you are seeing different results, maybe post your code (with = [product] [platform] and [version].. something similar to what I did. >=20 > Donovan >=20 >=20 >=20 > On Apr 19, 2017, at 10:20 PM, Stuart Tremain = wrote: >=20 >> Mmmm, thanks, I think =E2=80=A6=E2=80=A6 >>=20 >>=20 >>=20 >> Kind regards >>=20 >> Stuart Tremain >> Pharoah Lane Software >> AUSTRALIA >> webdna@idfk.com.au >>=20 >>=20 >>=20 >>=20 >>=20 >>=20 >>> On 20 Apr 2017, at 13:16, Donovan Brooke wrote: >>>=20 >>> Works here: >>> http://www.euca.us/admin/tests/cl/ >>>=20 >>>=20 >>> Donovan >>>=20 >>>=20 >>>=20 >>> On Apr 19, 2017, at 9: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 >>>=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 >>=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 >=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=_E1DB274F-1DE8-4606-8B8C-D85F1A50AEC6 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Thanks for the proof Donovan .

OK, I have it working now, I re-keyed = the search, maybe there was a typo I missed.

I did find that this: = clGRADEdata=3D2&clGRADEdata=3D1&GRADEtype=3Dnum

produced results with .5 = in it

1
2
1
2
.5
.5
1
.5
.5
.5
.5
.5
1
1
1
1
1
3
.5 is less than 1 so it = should not appear.






Kind regards

Stuart Tremain
Pharoah Lane = Software
AUSTRALIA
webdna@idfk.com.au






On 20 Apr 2017, at 13:25, Donovan Brooke <dbrooke@euca.us> = wrote:

If you are seeing different results, maybe post your code = (with [product] [platform] and [version].. something similar to what I = did.

Donovan


On Apr 19, 2017, at 10:20 PM, Stuart Tremain = <webdna@idfk.com.au> wrote:

Mmmm, thanks, I think = =E2=80=A6=E2=80=A6



Kind regards

Stuart Tremain
Pharoah Lane Software
AUSTRALIA
webdna@idfk.com.au





On 20 = Apr 2017, at 13:16, Donovan Brooke <dbrooke@euca.us> wrote:

Works here:
http://www.euca.us/admin/tests/cl/


Donovan



On Apr 19, 2017, at 9: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=3D= num


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 <talk@webdna.us>.
To = unsubscribe, E-mail to: <talk-leave@webdna.us>
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

---------------------------------------------------------
This message is sent to you because you are subscribed to
the mailing list <talk@webdna.us>.
To unsubscribe, E-mail = to: <talk-leave@webdna.us>
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=_E1DB274F-1DE8-4606-8B8C-D85F1A50AEC6-- . 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)
1161 --Apple-Mail=_E1DB274F-1DE8-4606-8B8C-D85F1A50AEC6 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Thanks for the proof Donovan . OK, I have it working now, I re-keyed the search, maybe there was a typo = I missed. I did find that this: clGRADEdata=3D2&clGRADEdata=3D1&GRADEtype=3Dnum produced results with .5 in it 1 2 1 2 ..5 ..5 1 ..5 ..5 ..5 ..5 ..5 1 1 1 1 1 3 ..5 is less than 1 so it should not appear. Kind regards Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@idfk.com.au > On 20 Apr 2017, at 13:25, Donovan Brooke wrote: >=20 > If you are seeing different results, maybe post your code (with = [product] [platform] and [version].. something similar to what I did. >=20 > Donovan >=20 >=20 >=20 > On Apr 19, 2017, at 10:20 PM, Stuart Tremain = wrote: >=20 >> Mmmm, thanks, I think =E2=80=A6=E2=80=A6 >>=20 >>=20 >>=20 >> Kind regards >>=20 >> Stuart Tremain >> Pharoah Lane Software >> AUSTRALIA >> webdna@idfk.com.au >>=20 >>=20 >>=20 >>=20 >>=20 >>=20 >>> On 20 Apr 2017, at 13:16, Donovan Brooke wrote: >>>=20 >>> Works here: >>> http://www.euca.us/admin/tests/cl/ >>>=20 >>>=20 >>> Donovan >>>=20 >>>=20 >>>=20 >>> On Apr 19, 2017, at 9: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 >>>=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 >>=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 >=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=_E1DB274F-1DE8-4606-8B8C-D85F1A50AEC6 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Thanks for the proof Donovan .

OK, I have it working now, I re-keyed = the search, maybe there was a typo I missed.

I did find that this: = clGRADEdata=3D2&clGRADEdata=3D1&GRADEtype=3Dnum

produced results with .5 = in it

1
2
1
2
.5
.5
1
.5
.5
.5
.5
.5
1
1
1
1
1
3
.5 is less than 1 so it = should not appear.






Kind regards

Stuart Tremain
Pharoah Lane = Software
AUSTRALIA
webdna@idfk.com.au






On 20 Apr 2017, at 13:25, Donovan Brooke <dbrooke@euca.us> = wrote:

If you are seeing different results, maybe post your code = (with [product] [platform] and [version].. something similar to what I = did.

Donovan


On Apr 19, 2017, at 10:20 PM, Stuart Tremain = <webdna@idfk.com.au> wrote:

Mmmm, thanks, I think = =E2=80=A6=E2=80=A6



Kind regards

Stuart Tremain
Pharoah Lane Software
AUSTRALIA
webdna@idfk.com.au





On 20 = Apr 2017, at 13:16, Donovan Brooke <dbrooke@euca.us> wrote:

Works here:
http://www.euca.us/admin/tests/cl/


Donovan



On Apr 19, 2017, at 9: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=3D= num


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 <talk@webdna.us>.
To = unsubscribe, E-mail to: <talk-leave@webdna.us>
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

---------------------------------------------------------
This message is sent to you because you are subscribed to
the mailing list <talk@webdna.us>.
To unsubscribe, E-mail = to: <talk-leave@webdna.us>
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=_E1DB274F-1DE8-4606-8B8C-D85F1A50AEC6-- . Stuart Tremain

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:

Forms Search Questions (1997) WebCat2b13MacPlugIn - More limits on [include] (1997) Webcat causing crashes left and right! (1997) [include] affect on filepaths for links? (1997) [isfile] ? (1997) WebCat2_Mac RETURNs in .db (1997) Anyone running WebMerchant 4.0? (2000) [WebDNA] Ubuntu 18.04 & Apache2 & WebDNA fcgi - File upload error (2019) Re2: frames & carts (1997) includes and cart numbers (1997) ImageMagick and [shell] (2003) Moment of Thanks (1997) Re1000001: Setting up shop (1997) Cold Fusion Buster (1997) IE-caching (1998) File Upload (1997) dates and hex formatting (1997) RE: New WebCatalog Version !!! (1997) PCS Frames (1997) RE: Web*SSL and WebCatalog (1997)