Re: [WebDNA] Search using CL

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113562
interpreted = N
texte = 1157 If you are seeing different results, maybe post your code (with = [product] [platform] and [version].. something similar to what I did. Donovan On 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 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)
1157 If you are seeing different results, maybe post your code (with = [product] [platform] and [version].. something similar to what I did. Donovan On 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 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:

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)