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:
Order file numbers different than the cart number. why? (2000)
Email (1998)
New to WebCat, Help. (1998)
SetLineItem (1997)
NT BETA BUG???? (1997)
referrer usage (1997)
Newbie needs advice to learn to use WebDNA (2003)
(2004)
[shownext] (1998)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
Proper file locations (1997)
[isfile] ? (1997)
Sorry I didn't pay attention-but ??? (1997)
Email within tmpl ? (1997)
Ooops-Serial Number for NT (1997)
question: back button prevention (1997)
frames & carts (1997)
RE: How to verify email address (1997)
WebCat2b13MacPlugIn - [include] (1997)
Error:Too many nested [xxx] contexts (1997)