Re: [WebDNA] Search using CL

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113560
interpreted = N
texte = 1155 Works here: http://www.euca.us/admin/tests/cl/ Donovan On Apr 19, 2017, at 9:30 PM, Stuart Tremain wrote: > I am looking at using the cl comparison in a search but can=92t 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 --------------------------------------------------------- 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 . 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)
1155 Works here: http://www.euca.us/admin/tests/cl/ Donovan On Apr 19, 2017, at 9:30 PM, Stuart Tremain wrote: > I am looking at using the cl comparison in a search but can=92t 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 --------------------------------------------------------- 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 . Donovan Brooke

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:

Problems with [Applescript] (1997) RequiredFields template (1997) [url] (1997) Need relative path explanation (1997) FW: Shipping calculations (1997) What am I missing (1997) Webcat table size. (2001) HideIf ip= OR ip (1998) [WriteFile] problems (1997) multi-paragraph fields (1997) RE: Problem (1997) Search in 2 or more catalogs (1997) pulldown menu differences (2005) [TaxableTotal] - not working with AOL and IE (1997) read and write you own cookies with webcat (1997) Sendmail Question (2001) Online reference (1997) emailer on Windows Beta 18 (1997) [WebDNA] Problem with SendMail - seems succesfull but nothing to (2016) Quit revisited (1997)