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)
Windows 2003 Web Edition and WebCatalog 6.0a Guide (2006)
RE: Languages (1997)
Re:Change WebDNA-Talk Mail due to no digest for 1wk (1997)
Runnaway Trigger (2007)
Mass-mailer options - any suggestions ? (2005)
2.0 Beta (1997)
Authorize.net SIM/AIM deadline extended (2003)
Reversed words (1997)
move files (2000)
Emailer setup (1997)
WebMerchant and CyberCash Problem: repost (2000)
Removing [showif] makes a big difference in speed (1997)
multiple prices (1998)
Errant Email. (1998)
Not reading code (1997)
Text data with spaces in them... (1997)
[WebDNA] grep again (2010)
No Data Results (1997)
Re:no [search] with NT (1997)