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 & Publishers8616 Joseph AveSt. Louis, MO 63144voice 314-962-4024email: webmaster@cybermill.comhttp://www.cybermill.com/__________________________________________________________We are not responsible for any misspelling or misinformationplease 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 & Publishers8616 Joseph AveSt. Louis, MO 63144voice 314-962-4024email: webmaster@cybermill.comhttp://www.cybermill.com/__________________________________________________________We are not responsible for any misspelling or misinformationplease 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:
Plugin or CGI or both (1997)
Displaying photo attached to first record (1997)
WebCatalog for Postcards ? (1997)
Pipes instead of tabs (1998)
carriage returns in data (1997)
New Command prefs ... (1997)
[accountNum] and [math] (1997)
RE: 2nd WebCatalog2 Feature Request (1996)
WebCat B13 Mac CGI -- Frames question (1997)
Secured Order Forms (1998)
Fun with Dates - any progress? (1997)
Decimal point in search.... (2004)
Navigator Parsing (1997)
Carts? (1998)
WebCat2.0 [format thousands .0f] no go (1997)
[replaceChars] would be nice ... (1997)
Extended [ConvertChars] (1997)
Multi-processor Mac info ... (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
[OT] WebDNA and MyODBC (2003)