Date comparison has serious bug ...
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 16974
interpreted = N
texte = >On 4/8/98 9:17 PM, Kenneth Grome wrote: > >>Clearly it *should* delete the first 4 records because both the dates AND >>the times are *less than* the current date and time, which is 04/08/1998 >>and 16:12:00 ... so, is there a bug in WebCatalog's code that's causing >>this problem? >> >>Or is there a better way of coding this stuff so that it actually works? > >I cannot say for sure as I have not experimented with this, but, could it >be the fact that [time] is not comparable in the way you are trying to >compare it. I see that you specified deletedatetype=date, but there is no >specification for the deletetime. Now I know that there is no >deletetimetype=time qualifier, but, maybe the problem is it cannot >compare 01:31:25 to 02:35:25. The colons would possibly interfere with >its operation. > >Eliminate the time qualifier to see if this is true. Actually, the time qualifier *can* be compared as text, since the time divisions are listed in order from the largest component to the smallest AND since each component always has the same number of characters.But I *did* eliminate the time qualifier in a later test anyways, just to see if that's what was screwing up, and my changes had no effect on the results. Good thought though, thanks Robert! :)Grant, I think this will require your investigation ...Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net
Associated Messages, from the most recent to the oldest:
| |
- Date comparison has serious bug ... (Kenneth Grome 1998)
|
>On 4/8/98 9:17 PM, Kenneth Grome wrote: > >>Clearly it *should* delete the first 4 records because both the dates AND >>the times are *less than* the current date and time, which is 04/08/1998 >>and 16:12:00 ... so, is there a bug in WebCatalog's code that's causing >>this problem? >> >>Or is there a better way of coding this stuff so that it actually works? > >I cannot say for sure as I have not experimented with this, but, could it >be the fact that
[time] is not comparable in the way you are trying to >compare it. I see that you specified deletedatetype=date, but there is no >specification for the deletetime. Now I know that there is no >deletetimetype=time qualifier, but, maybe the problem is it cannot >compare 01:31:25 to 02:35:25. The colons would possibly interfere with >its operation. > >Eliminate the time qualifier to see if this is true. Actually, the time qualifier *can* be compared as text, since the time divisions are listed in order from the largest component to the smallest AND since each component always has the same number of characters.But I *did* eliminate the time qualifier in a later test anyways, just to see if that's what was screwing up, and my changes had no effect on the results. Good thought though, thanks Robert! :)Grant, I think this will require your investigation ...Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://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:
WebCatalog can't find database (1997)
searchable list archive (1997)
letterrip and webcats emailer (1998)
Download Question (1997)
WebCatalog for Postcards ? (1997)
in conversions.db crashes unix webcat (1999)
Forms Search Questions (1997)
[WebDNA] Search using CL (2017)
Looking for WebCat hosting (2000)
[CART] inside a [LOOP] (1997)
Banners (1997)
WC 4.0 on OSX 10.0.4 problems (2001)
[WebDNA] WebDNA Development server (2018)
RE: Re:Has this happened to you? (1997)
Date search - yes or no (1997)
template includes encrypted template (1999)
Sorting... stumped. (2006)
WCS Newbie question (1997)
[WebDNA] blogger (2009)
Web Archives (2003)