Date comparison (I think) has bugs ...

This WebDNA talk-list message is from

1998

It keeps the original formatting. numero = 16951
interpreted = N
texte = Here's another test regarding the date comparison bug I'm investigating. This time I simplified the search as well as the database itself -- in order to help pinpoint the problem.Now the activeCarts.db has only two fields in it, cartID and deleteDate. It looked like this before I did the search:2974902097340 04/04/19982974902111366 04/05/19982974902122381 04/06/19982974902129396 04/07/19982974902135411 04/08/19982974902143426 04/09/19982974902150441 04/10/1998And it looks like this afterwards:2974902122381 04/06/19982974902135411 04/08/19982974902236457 04/10/1998And here's the WebDNA code that did the *wrong* thing:[search db=activeCarts.db&ledeleteDatedatarq=[date]&deleteDatetype=date][founditems][delete db=activeCarts.db&eqcartIDdatarq=[cartID]][/founditems][/search]Clearly it should NOT have removed the 04/09 record but it did ... and it *should have* removed the 04/06 and 04/08 records but it did not. This seems to point to a date comparison problem.Why WebCatalog seems to be retrieving the wrong records I have no idea. But this seems like a pretty serious problem ... :(Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net Associated Messages, from the most recent to the oldest:

Date comparison (I think) has bugs ... (Kenneth Grome 1998)

Here's another test regarding the date comparison bug I'm investigating. This time I simplified the search as well as the database itself -- in order to help pinpoint the problem.Now the activeCarts.db has only two fields in it, cartID and deleteDate. It looked like this before I did the search:2974902097340 04/04/19982974902111366 04/05/19982974902122381 04/06/19982974902129396 04/07/19982974902135411 04/08/19982974902143426 04/09/19982974902150441 04/10/1998And it looks like this afterwards:2974902122381 04/06/19982974902135411 04/08/19982974902236457 04/10/1998And here's the WebDNA code that did the *wrong* thing:[search db=activeCarts.db&ledeleteDatedatarq=[date]&deleteDatetype=date][founditems][delete db=activeCarts.db&eqcartIDdatarq=[cartID]][/founditems][/search]Clearly it should NOT have removed the 04/09 record but it did ... and it *should have* removed the 04/06 and 04/08 records but it did not. This seems to point to a date comparison problem.Why WebCatalog seems to be retrieving the wrong records I have no idea. But this seems like a pretty serious problem ... :(Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net Kenneth Grome

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:

[WebDNA] Triggers.db wiped completely blank (2011) Automatic thumbnail images (1998) [Announce]: Web server security and password protection (1997) unable to launch acgi in WebCat (1997) Tab Charactor (1997) Database wiped clean (2005) Help!!!! Purchases not going through! FIXED! (1997) multiple search commands (1997) Offer from ClearWay: Accelerate WebCatalog With ClearWay NITROPowerPlug! (1999) Signal Raised Error (1997) Erotic Sites (1997) typhoon... (1997) [Announce] WebCatalog 3.0 Beta Program (1998) WCS Newbie question (1997) [format 40s]text[/format] doesn't work (1997) docs for WebCatalog2 (1997) Need help with emailer- 2 issues (1997) ListFields and [name] (1997) empty shopping cart message (1997) & not allowed in db by definition? (1999)