Re: Date or time comparisons have bugs ...
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 16955
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. As for an answer to this possible problem, how 'bout a type=time qualifier from Grant? Robert Minor__________________________________________________________ CyberMill Website Designers & Publishers 8616 Joseph Ave St. Louis, MO 63144 voice 314-962-4024 email: webmaster@cybermill.com http://www.cybermill.com/ __________________________________________________________ We are not responsible for any misspelling or misinformation please check with your internet provider for defects.
Associated Messages, from the most recent to the oldest:
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. As for an answer to this possible problem, how 'bout a type=time qualifier from Grant? Robert Minor__________________________________________________________ CyberMill Website Designers & Publishers 8616 Joseph Ave St. Louis, MO 63144 voice 314-962-4024 email: webmaster@cybermill.com http://www.cybermill.com/ __________________________________________________________ We are not responsible for any misspelling or misinformation please check with your internet provider for defects.
Bob Minor
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:
Shopping carts and reloading pages (1997)
SIMS setup (1998)
WebCat2b12 - nesting [tags] (1997)
mail list (1998)
Repost: Orderfile, Grandtotal: How do I get it to all add up. (2000)
PCS Emailer's role ? (1997)
emailer (1997)
plugin-acgi, different results (1997)
[append] vs. [appendfile] delta + question? (1997)
remotely add + sign (1997)
The Archives? (1999)
Relay link (2002)
Emailer help....! (1997)
RE: type 2 errors with ssl server (1997)
Multi-processor Mac info ... (1997)
Encrypting WebDNA Templates (1999)
Problem (1997)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
Help! WebCat2 bug (1997)
Catalogs and W* (1996)