Re: [WebDNA] Search using CL
This WebDNA talk-list message is from 2017
It keeps the original formatting.
numero = 113562
interpreted = N
texte = 1157If you are seeing different results, maybe post your code (with =[product] [platform] and [version].. something similar to what I did.DonovanOn Apr 19, 2017, at 10:20 PM, Stuart Tremain
wrote:> Mmmm, thanks, I think =85=85>=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=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>>=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---------------------------------------------------------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:
1157If you are seeing different results, maybe post your code (with =[product] [platform] and [version].. something similar to what I did.DonovanOn Apr 19, 2017, at 10:20 PM, Stuart Tremain wrote:> Mmmm, thanks, I think =85=85>=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=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>>=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---------------------------------------------------------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:
Emailer (1997)
Install WebDNA 6.0 into MAMP/Apache 2.0 on OS X ... (2005)
Tiny Store: Remove Line Item? (2000)
Re:PCS Customer submissions ? (1997)
Does update cart input have to be a submit? (2005)
Re2: Calculating multiple shipping... (1997)
Writefile (2000)
[TCPconnect].... (2001)
Searching Dates (2000)
WebCatalog/WebMerchant 2.1 (1998)
Newbie trouble with [url] & [foundItems] (2000)
[lookup] vs. [search] (1998)
Why this code works from some places and doesn't from others? (2000)
WebCat2 beta FTP site (1997)
shownext problems (1998)
[format] question (2000)
WebCat b15 Mac plug-in (1997)
Beta5??? (2000)
Problems with [Applescript] (1997)
embedded [showif] statements (2000)