Re: [WebDNA] Search comparisons in 8.6.1

This WebDNA talk-list message is from

2019


It keeps the original formatting.
numero = 114713
interpreted = N
texte = 2335 --Apple-Mail=_44DFD22A-8477-47FF-8630-9D18175E0F8E Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii what happens if you do: &geNUMDATEdatarq=3D Kind regards Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@plsoftware.com.au > 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=3Dnum >=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 --Apple-Mail=_44DFD22A-8477-47FF-8630-9D18175E0F8E Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii 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 --Apple-Mail=_44DFD22A-8477-47FF-8630-9D18175E0F8E-- . 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)
2335 --Apple-Mail=_44DFD22A-8477-47FF-8630-9D18175E0F8E Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii what happens if you do: &geNUMDATEdatarq=3D Kind regards Stuart Tremain Pharoah Lane Software AUSTRALIA webdna@plsoftware.com.au > 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=3Dnum >=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 --Apple-Mail=_44DFD22A-8477-47FF-8630-9D18175E0F8E Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii 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 --Apple-Mail=_44DFD22A-8477-47FF-8630-9D18175E0F8E-- . Stuart Tremain

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:

Database Updates (1997) [GROUPS] followup (1997) searching by date range help needed (1997) List Address Changed! (1998) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) Emailer again & again (1997) URGENT - Server dying on me.... (2004) dynamic list of form variables (2003) Emailer setup (1997) Blacklisted (2002) WC 4.02rc2/WebStar (2001) [WriteFile] problems (1997) WebCat2 - [format thousands] (1997) Three new problems ... (1997) Updating a database once per day - An example (1998) Wow .. (2003) Credit card types (1997) serial number generation (1997) Multiple database search (2000) WebCat.acgi from /cgi-bin/? (1997)