Re: Problem with summary on date / inconsequent webcat behaviour
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19109
interpreted = N
texte = Per Christian Lied wrote:> I am having trouble with a search that goes something like this: > > [search db=program.db&rnp_date=12/1/98 > 12/31/98&p_datetype=date&p_datesort=1&p_datesumm=t] > [/search] > > The database in question contains about 250 records. > > When i run this search, webcat doesnt summ the fields right. It summs some > of them, but not all. What fields that is summed right, varies. > Also, when hitting this search repeatedly, webstar quits. > > I hope someone on the list can help, because I have to solve this problem > pretty quick to meet a deadline. > > Per Christian LiedChristian, I don't know if this is going to help or not if you're on a deadline, but I had all kinds of problems with WebSTAR crashes when working with dates. I followed Ken's advice and stored dates as numbers in my databases. Now searches are much faster and no crashes. I don't recall the URL of the info from Ken, but he had posted guidelines for using this format for dates on his site. Maybe someone else has the URL handy.-- Gil Poulsen, Webmaster************************************************************** * AltiM@c * Phone: (908) 222-9001 * * 111 Mali Drive * FAX: (908) 222-9002 * * North Plainfield, NJ * e-mail: help@altimac.com * * 07062-2355 * WWW: http://www.altimac.com * **************************************************************
Associated Messages, from the most recent to the oldest:
Per Christian Lied wrote:> I am having trouble with a search that goes something like this: > > [search db=program.db&rnp_date=12/1/98 > 12/31/98&p_datetype=date&p_datesort=1&p_datesumm=t] > [/search] > > The database in question contains about 250 records. > > When i run this search, webcat doesnt summ the fields right. It summs some > of them, but not all. What fields that is summed right, varies. > Also, when hitting this search repeatedly, webstar quits. > > I hope someone on the list can help, because I have to solve this problem > pretty quick to meet a deadline. > > Per Christian LiedChristian, I don't know if this is going to help or not if you're on a deadline, but I had all kinds of problems with WebSTAR crashes when working with dates. I followed Ken's advice and stored dates as numbers in my databases. Now searches are much faster and no crashes. I don't recall the URL of the info from Ken, but he had posted guidelines for using this format for dates on his site. Maybe someone else has the URL handy.-- Gil Poulsen, Webmaster************************************************************** * AltiM@c * Phone: (908) 222-9001 * * 111 Mali Drive * FAX: (908) 222-9002 * * North Plainfield, NJ * e-mail: help@altimac.com * * 07062-2355 * 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:
A Global Variable (1997)
[WebDNA] WebDNA 6.2 and Mac OS X 10.5 Client / Server ? (2009)
WebCatalog-NT?'s (1996)
RE: Timer Values on [redirect] (1998)
Mac: LModelDirector bug fix (1997)
WebCatalog for Dummies p.1 (2000)
Refering page (1998)
Writefile, Raw & include (2002)
Sending order notification by fax (1999)
Calendar (1997)
oops private message leaked into talk list (1997)
help with autenticate (1998)
Permission denied? (2004)
WC2b12: Yes, Formulas.db is for real (1997)
Separate SSL Server (1997)
WebTen? (1997)
WCS Newbie question (1997)
Search Folder? (1998)
Other then credit cards-how? (1997)
NT Setup (1998)