Date or time comparisons have bugs ...
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 16949
interpreted = N
texte = I have three fields in this.db: cartID, deleteDate and deleteTime, corresponding to the following data:296987757 02/10/1998 13:59:35 296987758 02/10/1998 13:59:49 296987760 02/10/1998 14:00:00 297229722 03/10/1998 14:07:10 297422049 04/01/1998 20:21:39 297489625 04/09/1998 16:04:12 297489636 04/09/1998 16:06:08 My code, which is designed to delete records, looks like this:[search db=this.db&ledeleteDatedatarq=[date]&ledeleteTimedatarq=[time]&deleteDatetype=date] [founditems] [delete db=this.db&eqcartIDdatarq=[cartID]] [/founditems] [/search]So why doesn't it delete all but the last three records?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?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:
I have three fields in this.db: cartID, deleteDate and deleteTime, corresponding to the following data:296987757 02/10/1998 13:59:35 296987758 02/10/1998 13:59:49 296987760 02/10/1998 14:00:00 297229722 03/10/1998 14:07:10 297422049 04/01/1998 20:21:39 297489625 04/09/1998 16:04:12 297489636 04/09/1998 16:06:08 My code, which is designed to delete records, looks like this:[search db=this.db&ledeleteDatedatarq=
[date]&ledeleteTimedatarq=
[time]&deleteDatetype=date]
[founditems] [delete db=this.db&eqcartIDdatarq=[cartID]] [/founditems] [/search]So why doesn't it delete all but the last three records?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?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:
tab as word delimiter (2000)
OPEN MARKET PATENTS SOUND ECOMMERCE ALARM (1998)
List archive status? (1999)
multi-paragraph fields (1997)
Webcat/Webmerchant part II (1998)
Urgent Help needed (1998)
Moment of Thanks (1997)
Problems problems problems (1997)
File upload woes (1998)
Large Database Issue (possible bug) (2004)
Webcat no longer supported? (2006)
Nesting format tags (1997)
Can't use old cart file (was One more try) (1997)
preserving the zero's (1999)
The code, one more time. (2003)
Multiple prices (1997)
Grouping search fields, etc. (1997)
[WebDNA] Processor Maxing out (2010)
WebCat2 as a chat server? (1997)
Can WebDNA do this? (2000)