Date search bug
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17636
interpreted = N
texte = Ken commented on this privately earlier, but I wanted to bring it back to the list now because it appears to be a legitimate bug.Using WebCat plug-in 2.1.3; WebSTAR 3.0 with plenty of RAM allocated, the following search context in one of my templates causes WebSTAR to choke for 2-3 seconds, and then crash completely:
When I remove the &accdatetype=date from the search context, it processes it in less than a second and doesn't crash WebSTAR. Otherwise, it takes 1-2 seconds to return or it crashes completely. It seems to be searching fine without the type=date. The accdate field is in the form of mm/dd/yyyy.As Ken noted, this type of search will work properly without defining the field as a type=date, but other searches will not. The database only has about 100 entries in it at this point, certainly nowhere near large enough to stall WebCat. I thought 2.1.3 might fix the problem, but it made no difference.-- Gil Poulsen, Webmaster************************************************************** * AltiM@c * Phone: (732) 469-2567 * * 429 St. Giles Court * FAX: (732) 469-5823 * * Somerset, NJ * e-mail: help@altimac.com * * 08873 * WWW: http://www.altimac.com * **************************************************************
Associated Messages, from the most recent to the oldest:
Ken commented on this privately earlier, but I wanted to bring it back to the list now because it appears to be a legitimate bug.Using WebCat plug-in 2.1.3; WebSTAR 3.0 with plenty of RAM allocated, the following search context in one of my templates causes WebSTAR to choke for 2-3 seconds, and then crash completely:
When I remove the &accdatetype=date from the search context, it processes it in less than a second and doesn't crash WebSTAR. Otherwise, it takes 1-2 seconds to return or it crashes completely. It seems to be searching fine without the type=date. The accdate field is in the form of mm/dd/yyyy.As Ken noted, this type of search will work properly without defining the field as a type=date, but other searches will not. The database only has about 100 entries in it at this point, certainly nowhere near large enough to stall WebCat. I thought 2.1.3 might fix the problem, but it made no difference.-- Gil Poulsen, Webmaster************************************************************** * AltiM@c * Phone: (732) 469-2567 * * 429 St. Giles Court * FAX: (732) 469-5823 * * Somerset, NJ * e-mail: help@altimac.com * * 08873 * WWW: http://www.altimac.com * **************************************************************
Gil Poulsen
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:
Open Databases on Restart (1999)
Suffix Mapping????? (1998)
Backwards list behavior ... (1997)
[applescript] (1999)
Help with dates (2001)
Click-through/Referral tracking solution needed (2000)
Download (1999)
webcat2b12 CGI -- Date comparisons (1997)
Applescript in Webcatalog problem (1997)
[sendmail] and [formvariables] (1997)
Too Much Rootbeer Free Offer (1997)
grep for search, not replace (2002)
Not really WebCat (1997)
emailer (1997)
[WebDNA] Count Lines (2011)
pc (1997)
View order not right (1997)
Interfacing a webcat front end registartion to CommunigatePRO (2000)
Help name our technology! (1997)
Checking Out! (1999)