Re: [WebDNA] Search comparisons in 8.6.1

This WebDNA talk-list message is from

2019


It keeps the original formatting.
numero = 114718
interpreted = N
texte = 2341 --Apple-Mail=_664037BD-40B7-4F50-9796-7BCE5908C23A Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 On second look, today.. it looks like gt is supposed to be gr.. .but the = docs were saying gt.. well, some of them: http://www.webdna.us/page.dna?numero=3D69 = " Bedrooms > 5 and fireplace is True and Bathrooms is 2= gtBedsdatarq=3D5&eqFireplacedatarq=3DT&eqBathsdatarq=3D2 =E2=80=9C Anyway, gr appears to work. Back to your regularly sched. programming.=20= D > On Aug 29, 2019, at 2:07 PM, Donovan Brooke wrote: >=20 > =E2=80=98ge=E2=80=99 works.=20 > Looks like gt / le are broken. For WSC / others.. here is the very = basic framework of my code in order to reproduce the error: > (It may be reproducible with the simple inside search.. I have not = tried) >=20 > Also, webdna.us appears to be down :-/=20 >=20 > [math show=3DF]sevendaysago=3D{[date]}-7[/math] > [switch value=3D[val]] > [case value=3Dblah] > [!] vIds =3D pipe delimited string of ID's [/!] > [listwords words=3D[vIDs]&delimiters=3D|] > [hideif [blahblah]=3Dskip] > [search = db=3Dsome.db&eqsIDdatarq=3D[url][word][/url]] > 

ID: [word]

> 
    > [founditems] > [search = db=3Dother.db&eqsIDdatarq=3D[url][sUID][/url]>dPUBDATEdatarq=3D[url][sev= endaysago][/url]&dPUBDATEtype=3Dnum] > [founditems] > 
  • > = blah > 
    • > [/founditems] > [/search] > [/founditems] > 
> [/search] > [/hideif] > [/listwords] > [/case] > [/switch] >=20 >=20 >=20 >> On Aug 28, 2019, at 10:31 PM, Stuart Tremain = > wrote: >>=20 >> what happens if you do: >>=20 >> &geNUMDATEdatarq=3D >>=20 >>=20 >> Kind regards >>=20 >> Stuart Tremain >> Pharoah Lane Software >> AUSTRALIA >> webdna@plsoftware.com.au >>=20 >>=20 >>=20 >>=20 >>=20 >>=20 >>=20 >>> On 29 Aug 2019, at 13:21, Donovan Brooke > wrote: >>>=20 >>> WebDNA - Enterprise Edition, unix-Linux Intel, 8.6.1=20 >>>=20 >>> Anyone seeing a problem with greater than comparisons in 8.6.1?? >>>=20 >>> &eqsIDdatarq=3D[vID]>NUMDATEdatarq=3D[sevendaysago]&NUMDATEtype=3Dnu= m >>>=20 >>> It is returning records with the correct ID. >>>=20 >>> However, it also finding records where: >>> NUMDATE =3D 735310 >>> and >>> [sevendaysago] =3D 737657 >>>=20 >>> Changing to an lt comparison does not change the result. >>>=20 >>>=20 >>>=20 >>> Donovan Brooke >>> Owner - EUCA >>> (608) 770-3822 >>>=20 >>> 355 E State St. APT 8 >>> Iola, WI 54945 >>>=20 >>>=20 >>>=20 >>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list = talk@webdna.us To unsubscribe, E-mail to: = talk-leave@webdna.us archives: = http://www.webdna.us/page.dna?numero=3D55 = Bug Reporting: = support@webdna.us >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list = talk@webdna.us To unsubscribe, E-mail to: = talk-leave@webdna.us archives: = http://www.webdna.us/page.dna?numero=3D55 = Bug Reporting: = support@webdna.us > Donovan Brooke > Owner - EUCA > (608) 770-3822 >=20 > 355 E State St. APT 8 > Iola, WI 54945 >=20 >=20 >=20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list = talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: = http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: = support@webdna.us Donovan Brooke Owner - EUCA (608) 770-3822 355 E State St. APT 8 Iola, WI 54945 --Apple-Mail=_664037BD-40B7-4F50-9796-7BCE5908C23A Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 On = second look, today.. it looks like gt is supposed to be gr.. .but the = docs were saying gt.. well, some of them:

http://www.webdna.us/page.dna?numero=3D69
"
Bedrooms > 5 and = fireplace is True and Bathrooms is 2gtBedsdatarq=3D5&eqFireplacedatarq=3DT&eqBathsdatarq=3D2
=E2=80=9C


Anyway, gr appears to = work.  Back to your regularly sched. programming. 

D


On Aug = 29, 2019, at 2:07 PM, Donovan Brooke <dbrooke@euca.us> = wrote:

=E2=80=98ge=E2=80=99 = works. 
Looks like gt / le are broken.  For WSC = / others.. here is the very basic framework of my code in order to = reproduce the error:
(It may be reproducible with = the simple inside search.. I have not tried)

Also, webdna.us appears to be down :-/ 

[math show=3DF]sevendaysago=3D{[date]}-7[/math]
[switch value=3D[val]]
[case = value=3Dblah]
[!] vIds =3D pipe = delimited string of ID's [/!]
= [listwords words=3D[vIDs]&delimiters=3D|]
= [hideif [blahblah]=3Dskip]
= [search db=3Dsome.db&eqsIDdatarq=3D[url][word][/url]]
= <h3>ID: [word]</h3>
= <ul>
= [founditems]
= [search = db=3Dother.db&eqsIDdatarq=3D[url][sUID][/url]&gtdPUBDATEdatarq=3D[= url][sevendaysago][/url]&dPUBDATEtype=3Dnum]
= [founditems]
= = <li>
= blah
= </li>
= [/founditems]
= [/search]
= [/founditems]
= </ul>
= [/search]
= [/hideif]
[/listwords]
= [/case]
[/switch]



On Aug 28, 2019, at 10:31 PM, Stuart Tremain <webdna@plsoftware.com.au> wrote:

what happens if you = do:

&geNUMDATEdatarq=3D


Kind regards

Stuart Tremain
Pharoah Lane Software
AUSTRALIA







On 29 Aug 2019, at 13:21, Donovan Brooke <dbrooke@euca.us> = wrote:

WebDNA - Enterprise = Edition, unix-Linux Intel, 8.6.1 

Anyone seeing a problem with greater = than comparisons in 8.6.1??

&eqsIDdatarq=3D[vID]&gtNUMDATEdatarq=3D[sevendaysago]&a= mp;NUMDATEtype=3Dnum

It is returning records with the correct ID.

However, it also finding = records where:
NUMDATE =3D 735310
and
[sevendaysago] =3D 737657

Changing to an lt = comparison does not change the result.



Donovan Brooke
Owner - EUCA
(608) = 770-3822

355 E State St. APT 8
Iola, = WI 54945



--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us

Donovan Brooke
Owner - EUCA
(608) = 770-3822

355 E State St. APT 8
Iola, = WI 54945



--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us
Donovan Brooke
Owner - = EUCA
(608) 770-3822

355 E State St. APT 8
Iola, WI = 54945



= --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --Apple-Mail=_664037BD-40B7-4F50-9796-7BCE5908C23A-- . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Search comparisons in 8.6.1 (Donovan Brooke 2019)
  2. Re: [WebDNA] Search comparisons in 8.6.1 (Donovan Brooke 2019)
  3. Re: [WebDNA] Search comparisons in 8.6.1 (Stuart Tremain 2019)
  4. [WebDNA] Search comparisons in 8.6.1 (Donovan Brooke 2019)
2341 --Apple-Mail=_664037BD-40B7-4F50-9796-7BCE5908C23A Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 On second look, today.. it looks like gt is supposed to be gr.. .but the = docs were saying gt.. well, some of them: http://www.webdna.us/page.dna?numero=3D69 = " Bedrooms > 5 and fireplace is True and Bathrooms is 2= gtBedsdatarq=3D5&eqFireplacedatarq=3DT&eqBathsdatarq=3D2 =E2=80=9C Anyway, gr appears to work. Back to your regularly sched. programming.=20= D > On Aug 29, 2019, at 2:07 PM, Donovan Brooke wrote: >=20 > =E2=80=98ge=E2=80=99 works.=20 > Looks like gt / le are broken. For WSC / others.. here is the very = basic framework of my code in order to reproduce the error: > (It may be reproducible with the simple inside search.. I have not = tried) >=20 > Also, webdna.us appears to be down :-/=20 >=20 > [math show=3DF]sevendaysago=3D{[date]}-7[/math] > [switch value=3D[val]] > [case value=3Dblah] > [!] vIds =3D pipe delimited string of ID's [/!] > [listwords words=3D[vIDs]&delimiters=3D|] > [hideif [blahblah]=3Dskip] > [search = db=3Dsome.db&eqsIDdatarq=3D[url][word][/url]] > 

ID: [word]

> 
    > [founditems] > [search = db=3Dother.db&eqsIDdatarq=3D[url][sUID][/url]>dPUBDATEdatarq=3D[url][sev= endaysago][/url]&dPUBDATEtype=3Dnum] > [founditems] > 
  • > = blah > 
    • > [/founditems] > [/search] > [/founditems] > 
> [/search] > [/hideif] > [/listwords] > [/case] > [/switch] >=20 >=20 >=20 >> On Aug 28, 2019, at 10:31 PM, Stuart Tremain = > wrote: >>=20 >> what happens if you do: >>=20 >> &geNUMDATEdatarq=3D >>=20 >>=20 >> Kind regards >>=20 >> Stuart Tremain >> Pharoah Lane Software >> AUSTRALIA >> webdna@plsoftware.com.au >>=20 >>=20 >>=20 >>=20 >>=20 >>=20 >>=20 >>> On 29 Aug 2019, at 13:21, Donovan Brooke > wrote: >>>=20 >>> WebDNA - Enterprise Edition, unix-Linux Intel, 8.6.1=20 >>>=20 >>> Anyone seeing a problem with greater than comparisons in 8.6.1?? >>>=20 >>> &eqsIDdatarq=3D[vID]>NUMDATEdatarq=3D[sevendaysago]&NUMDATEtype=3Dnu= m >>>=20 >>> It is returning records with the correct ID. >>>=20 >>> However, it also finding records where: >>> NUMDATE =3D 735310 >>> and >>> [sevendaysago] =3D 737657 >>>=20 >>> Changing to an lt comparison does not change the result. >>>=20 >>>=20 >>>=20 >>> Donovan Brooke >>> Owner - EUCA >>> (608) 770-3822 >>>=20 >>> 355 E State St. APT 8 >>> Iola, WI 54945 >>>=20 >>>=20 >>>=20 >>> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list = talk@webdna.us To unsubscribe, E-mail to: = talk-leave@webdna.us archives: = http://www.webdna.us/page.dna?numero=3D55 = Bug Reporting: = support@webdna.us >> --------------------------------------------------------- This = message is sent to you because you are subscribed to the mailing list = talk@webdna.us To unsubscribe, E-mail to: = talk-leave@webdna.us archives: = http://www.webdna.us/page.dna?numero=3D55 = Bug Reporting: = support@webdna.us > Donovan Brooke > Owner - EUCA > (608) 770-3822 >=20 > 355 E State St. APT 8 > Iola, WI 54945 >=20 >=20 >=20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list = talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: = http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: = support@webdna.us Donovan Brooke Owner - EUCA (608) 770-3822 355 E State St. APT 8 Iola, WI 54945 --Apple-Mail=_664037BD-40B7-4F50-9796-7BCE5908C23A Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 On = second look, today.. it looks like gt is supposed to be gr.. .but the = docs were saying gt.. well, some of them:

http://www.webdna.us/page.dna?numero=3D69
"
Bedrooms > 5 and = fireplace is True and Bathrooms is 2gtBedsdatarq=3D5&eqFireplacedatarq=3DT&eqBathsdatarq=3D2
=E2=80=9C


Anyway, gr appears to = work.  Back to your regularly sched. programming. 

D


On Aug = 29, 2019, at 2:07 PM, Donovan Brooke <dbrooke@euca.us> = wrote:

=E2=80=98ge=E2=80=99 = works. 
Looks like gt / le are broken.  For WSC = / others.. here is the very basic framework of my code in order to = reproduce the error:
(It may be reproducible with = the simple inside search.. I have not tried)

Also, webdna.us appears to be down :-/ 

[math show=3DF]sevendaysago=3D{[date]}-7[/math]
[switch value=3D[val]]
[case = value=3Dblah]
[!] vIds =3D pipe = delimited string of ID's [/!]
= [listwords words=3D[vIDs]&delimiters=3D|]
= [hideif [blahblah]=3Dskip]
= [search db=3Dsome.db&eqsIDdatarq=3D[url][word][/url]]
= <h3>ID: [word]</h3>
= <ul>
= [founditems]
= [search = db=3Dother.db&eqsIDdatarq=3D[url][sUID][/url]&gtdPUBDATEdatarq=3D[= url][sevendaysago][/url]&dPUBDATEtype=3Dnum]
= [founditems]
= = <li>
= blah
= </li>
= [/founditems]
= [/search]
= [/founditems]
= </ul>
= [/search]
= [/hideif]
[/listwords]
= [/case]
[/switch]



On Aug 28, 2019, at 10:31 PM, Stuart Tremain <webdna@plsoftware.com.au> wrote:

what happens if you = do:

&geNUMDATEdatarq=3D


Kind regards

Stuart Tremain
Pharoah Lane Software
AUSTRALIA







On 29 Aug 2019, at 13:21, Donovan Brooke <dbrooke@euca.us> = wrote:

WebDNA - Enterprise = Edition, unix-Linux Intel, 8.6.1 

Anyone seeing a problem with greater = than comparisons in 8.6.1??

&eqsIDdatarq=3D[vID]&gtNUMDATEdatarq=3D[sevendaysago]&a= mp;NUMDATEtype=3Dnum

It is returning records with the correct ID.

However, it also finding = records where:
NUMDATE =3D 735310
and
[sevendaysago] =3D 737657

Changing to an lt = comparison does not change the result.



Donovan Brooke
Owner - EUCA
(608) = 770-3822

355 E State St. APT 8
Iola, = WI 54945



--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us

Donovan Brooke
Owner - EUCA
(608) = 770-3822

355 E State St. APT 8
Iola, = WI 54945



--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us
Donovan Brooke
Owner - = EUCA
(608) 770-3822

355 E State St. APT 8
Iola, WI = 54945



= --------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list talk@webdna.us To unsubscribe, E-mail to: talk-leave@webdna.us archives: http://www.webdna.us/page.dna?numero=3D55 Bug Reporting: support@webdna.us --Apple-Mail=_664037BD-40B7-4F50-9796-7BCE5908C23A-- . 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:

[shell] (2002) Authenticating users without dialog box (1997) 911: testing if the field is empty (2000) database with 10,000+ web pages stored in it? (2000) [switch] platform specific bug??? (2003) WC2b15 File Corruption (1997) Join us at MacWorld! - Part 2 (1998) answers - opinions? (1998) Multiple prices (1997) SMSI: databases corrupted on crash and permission issuesonOSX (2002) Re[2]: 2nd WebCatalog2 Feature Request (1996) Virtual Domains (1998) Sorting by date (1997) Failure to document significant changes ... (2000) Orderfile context problem (1998) Sort Order on a page search (1997) Search/sort in URL Was: GuestBook example (1997) emailer w/F2 (1997) [WebDNA] FastCGI version confusion (2011) [OT] Death Clock (2003)