Re: [WebDNA] Search using CL
This WebDNA talk-list message is from 2017
It keeps the original formatting.
numero = 113560
interpreted = N
texte = 1155Works here:http://www.euca.us/admin/tests/cl/DonovanOn 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 tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us.
Associated Messages, from the most recent to the oldest:
1155Works here:http://www.euca.us/admin/tests/cl/DonovanOn 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 tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug 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)