Re: Date search bug

This WebDNA talk-list message is from

1998

It keeps the original formatting. numero = 17655
interpreted = N
texte = I discovered that the same syntax works fine when not enclosed in the tag, because that syntax appears on the very next page. Is it possible thatsomething strange is happening when WebCat tries to build a form popup from asummarized series of dates?John Hill wrote:> > [accdate] should not interfere with [date] as far as the search routines are concerned. This problem was fixed in 2.0 quite a while ago. How big is your database? Try taking out the summ=T - depending on the size of the database, this could require additional RAM.> > John.> > >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:> >> >> >> >

> >> > Search the access log by date:  

> >> > [search> >> > db=offshorelog.db&accdatetype=date&geaccdatedata=03/01/98&deaccdatesort=1&accdatesumm=T&max=150]> >> > [FoundItems]> >> > [accdate]> >> > [/FoundItems]> >> > [/search]> >> >     > >> > > >> >> >> > 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 *> >**************************************************************> > John A. Hill, V.P. Marketing> Pacific Coast Software> eCommerce / Web Developer Tools> http://www.smithmicro.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:

Re: Date search bug? (Kenneth Grome 1998) Re: Date search bug (Kenneth Grome 1998) Re: Date search bug (Gil Poulsen 1998) Re: Date search bug (Kenneth Grome 1998) Re: Date search bug (Gil Poulsen 1998) Re: Date search bug (John Hill 1998) Re: Date search bug (Gil Poulsen 1998) Date search bug (Gil Poulsen 1998) Re: Date search bug (nelson@fwgi.com 1998) Re: Date search bug (Kenneth Grome 1997) Date search bug (Kenneth Grome 1997)

I discovered that the same syntax works fine when not enclosed in the tag, because that syntax appears on the very next page. Is it possible thatsomething strange is happening when WebCat tries to build a form popup from asummarized series of dates?John Hill wrote:> > [accdate] should not interfere with [date] as far as the search routines are concerned. This problem was fixed in 2.0 quite a while ago. How big is your database? Try taking out the summ=T - depending on the size of the database, this could require additional RAM.> > John.> > >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:> >> >> >> >

> >> > Search the access log by date:  

> >> > [search> >> > db=offshorelog.db&accdatetype=date&geaccdatedata=03/01/98&deaccdatesort=1&accdatesumm=T&max=150]> >> > [founditems]> >> > [accdate]> >> > [/FoundItems]> >> > [/search]> >> >     > >> > > >> >> >> > 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 *> >**************************************************************> > John A. Hill, V.P. Marketing> Pacific Coast Software> eCommerce / Web Developer Tools> http://www.smithmicro.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:

Cookies and webcat (1997) Bug or syntax error on my part? (1997) dreamweaver mx (2002) Summing fields (1997) Rhapsody? (1997) [taxRate] [TaxTotal] ? (1997) InternetWeek E-Commerce article (1998) TCPconnect issue (2000) [Announce]: Web server security and password protection (1997) DB Emergency (2002) A matter of time (1997) form data submission gets truncated (1997) GD Spam (2003) [LOOKUP] (1997) emailer (1997) Searching multiple fields (1997) Search inside Include (1998) off-topic - printinglib 68K (1997) Using Plug-In while running 1.6.1 (1997) Mail Server Needed. (1998)