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:---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing listclose 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 resultsclGRADEdatarq=3D4&clGRADEdatarq=3D1&GRADEtype=3DnumI would expect that the search would return all rows =with grade =3D 3 or 4 or 5This also produces 0 resultsclGRADEdata=3D4&clGRADEdata=3D1&GRADEtype=3Dnum This does produce results but only when =the GRADE =3D 4clGRADEdata=3D4Any ideas ?WebDNA Server version 6.2.To unsubscribe, E-mail to: =div>archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us
|
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:---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing listclose 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 resultsclGRADEdatarq=3D4&clGRADEdatarq=3D1&GRADEtype=3DnumI would expect that the search would return all rows =with grade =3D 3 or 4 or 5This also produces 0 resultsclGRADEdata=3D4&clGRADEdata=3D1&GRADEtype=3Dnum This does produce results but only when =the GRADE =3D 4clGRADEdata=3D4Any ideas ?WebDNA Server version 6.2.To unsubscribe, E-mail to: =div>archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us
DOWNLOAD WEBDNA NOW!
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...