Search or delete (or date or time) has bugs ...
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 16950
interpreted = N
texte = With further testing, I have discovered that WebCatalog actually deletes *SOME* of the records each time the code is run -- it just doesn't delete them all at once like it should.And sometimes it deletes records it should not be deleting at all!When I click the browser's Reload button to reload the same page a second time, another two or three records were deleted. Then the next time I repeated that procedure by clicking the Reload button again, another two records were deleted!Clearly WebCatalog *should* be delete all the properly-matching records the first time, not a few now and maybe a few the next time around ...But what's really scary is that WebCat actually deleted a record dated 04/01/1998 with a time of 20:21:39, and it also deleted records with tomorrow's date!... but since it's nowhere near 20:21:39 yet today (and it certainly isn't tomorrow yet), this seems to indicate that my search:[search db=this.db&ledeleteDatedatarq=[date]&ledeleteTimedatarq=[time]&deleteDatetype=date]is failing to retrieve the proper records. Instead, it actually looks like WebCat is retrieving records that do not match all the parameters (even though I've clearly used rq to force all parameters to match), or that it's retrieving a different set of records each time.What's going on here ... ?Am I missing something very simple and obvious here, or does WebCatalog have some real problems dealing with date comparisons?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:
With further testing, I have discovered that WebCatalog actually deletes *SOME* of the records each time the code is run -- it just doesn't delete them all at once like it should.And sometimes it deletes records it should not be deleting at all!When I click the browser's Reload button to reload the same page a second time, another two or three records were deleted. Then the next time I repeated that procedure by clicking the Reload button again, another two records were deleted!Clearly WebCatalog *should* be delete all the properly-matching records the first time, not a few now and maybe a few the next time around ...But what's really scary is that WebCat actually deleted a record dated 04/01/1998 with a time of 20:21:39, and it also deleted records with tomorrow's date!... but since it's nowhere near 20:21:39 yet today (and it certainly isn't tomorrow yet), this seems to indicate that my search:[search db=this.db&ledeleteDatedatarq=
[date]&ledeleteTimedatarq=
[time]&deleteDatetype=date]is failing to retrieve the proper records. Instead, it actually looks like WebCat is retrieving records that do not match all the parameters (even though I've clearly used rq to force all parameters to match), or that it's retrieving a different set of records each time.What's going on here ... ?Am I missing something very simple and obvious here, or does WebCatalog have some real problems dealing with date comparisons?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:
Javascript Stored in a Database (2003)
problems with 2 tags shakur (1997)
[WebDNA] UTF-8 encoding issues (2010)
WebMerchant when CC network is down (1998)
problems with 2 tags (1997)
Running 2 two WebCatalog.acgi's (1996)
emailer error -108 (1997)
Emailer (1997)
Unknown error: OrderNotCreated (1997)
Looking for WebDNA 3.08 MAC (2003)
Fun with dates (1997)
Country & Ship-to address & other fields ? (1997)
Uh...can someone help me out with the b10? (1997)
Cold Fusion Buster (1997)
5.1: Can't enter serial number (2004)
WC2.0 Memory Requirements (1997)
Time comparison question (1998)
Error -108 (1997)
rotating thumbnails (1997)
expired beta (1997)