Re: [WebDNA] Search using CL

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113561
interpreted = N
texte = 1156 --Apple-Mail=_95582469-33E4-42FF-A764-AF5010A4661D Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 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 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 --Apple-Mail=_95582469-33E4-42FF-A764-AF5010A4661D Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Mmmm, thanks, I think =E2=80=A6=E2=80=A6



Kind regards

Stuart Tremain
Pharoah Lane Software
AUSTRALIA






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 --Apple-Mail=_95582469-33E4-42FF-A764-AF5010A4661D-- . 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)
1156 --Apple-Mail=_95582469-33E4-42FF-A764-AF5010A4661D Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 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 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 --Apple-Mail=_95582469-33E4-42FF-A764-AF5010A4661D Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 Mmmm, thanks, I think =E2=80=A6=E2=80=A6



Kind regards

Stuart Tremain
Pharoah Lane Software
AUSTRALIA






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 --Apple-Mail=_95582469-33E4-42FF-A764-AF5010A4661D-- . 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:

Re:2nd WebCatalog2 Feature Request (1996) Add more fields to an existent data base (1997) Wireless (2002) MacAuthorize and WebMerchant (1997) Shopping with Accounts (2003) Banner DNA (1997) Cookie Crumble (1998) Web Catalog 2 demo (1997) Speed questions (1998) ShowNext truncating passed variable?? (1997) WebCat2b13MacPlugin - [math][date][/math] problem (1997) WebDNA for Dummies (2004) Smith Micro Customer Service Sucks (2008) I think WebDNA-Talk died ... :( (1997) calculating ShipCost depending on weight (1997) Cancel Subscription (1996) Error Log.db --however (1997) WebCatalog Beta Documentation (1997) WebStar quitting since upgrading to WC4 (2000) [WebDNA] [OT] hello (2012)