Re: Date search bug
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17641
interpreted = N
texte = Hmmm. I did avoid [date] directly for that very reason, but you have a point there. I will attempt some tests with date totally removed from the fieldname and see what happens.nelson@fwgi.com wrote: > > Try this. It may or may not solve the problem, I have experienced problem when defining a field > name similar to a reserved word. In this case, the problem could lie > > [accdate] > > contains [date] which is reserved. > > try to use [accddd] or something like that and see if this possible bug will go away > > Nelson > > Gil Poulsen wrote: > > > 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, 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:
Hmmm. I did avoid
[date] directly for that very reason, but you have a point there. I will attempt some tests with date totally removed from the fieldname and see what happens.nelson@fwgi.com wrote: > > Try this. It may or may not solve the problem, I have experienced problem when defining a field > name similar to a reserved word. In this case, the problem could lie > > [accdate] > > contains
[date] which is reserved. > > try to use [accddd] or something like that and see if this possible bug will go away > > Nelson > > Gil Poulsen wrote: > > > 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, 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:
Bug Report, maybe (1997)
WebCat2b13MacPlugIn - syntax to convert date (1997)
PCS Frames (1997)
SiteGaurd file Cache vs webcatalog cache (1997)
Product Comparison (2000)
Webcatalog serving binary data (2000)
Cancel Subscription (1996)
quotation marks (2004)
Nested search (1997)
Emailer and encryption (1997)
Plugin or CGI or both (1997)
A Global Variable (1997)
[BoldWords WordList]Any Text[/BoldWords] (2000)
Hiding HTML and page breaks (1997)
The future of WebCatalog is coming with 4.0... (2000)
Capitalize special cases (2000)
Press Release hit the NewsWire!!! (1997)
Problems with SELECT MULTIPLE (1999)
Not really WebCat (1997)
problem serving foreign languages text (1997)