Re: Search context not finding recent entries
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17446
interpreted = N
texte = Yeah, that did it. I think I already knew that, but I went ahead and put inthe wrong tag anyway. Thanks Ken and PCS for setting me straight.Kenneth Grome wrote:> >I'm doing an [appendfile] to a database (offshorelog.db) each time a certain> >page is accessed by a user. When I then search that database using the> >following criteria:> >> >[search db=offshorelog.db&eqaccdatedata=[requesteddate]&accdatetype=date&deaccdatesort=1&deacctimesort=2&max=500]> >> >the most recent access(es) is/are not shown. By recent, I mean before the last> >time the database was closed manually by me. The only way I can get this to> >work is to insert a [closedatabase] tag in each of the pages that the users> >hit. Then this search works as expected.> >> >When I look at the database file on disk with BBEdit, the entries are indeed> >there, since [appendfile] writes to disk immediately. So is the> >[closedatabase] tag always required for something like this, or am I missing a> >tag somewhere?> > I think you're using [appendfile] where you should be using [append].> > [appendfile] is generally used to append data to non-db files, whereas [append] is used to append data directly to WebCatalog db files.> > Try using [append] instead of [appendfile], then the changes will appear *instantly* in your search/results page, because the data will be appended to WebCatalog's RAM-cached copy of that database first, before it is written to disk.-- 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:
Yeah, that did it. I think I already knew that, but I went ahead and put inthe wrong tag anyway. Thanks Ken and PCS for setting me straight.Kenneth Grome wrote:> >I'm doing an
[appendfile] to a database (offshorelog.db) each time a certain> >page is accessed by a user. When I then search that database using the> >following criteria:> >> >[search db=offshorelog.db&eqaccdatedata=[requesteddate]&accdatetype=date&deaccdatesort=1&deacctimesort=2&max=500]> >> >the most recent access(es) is/are not shown. By recent, I mean before the last> >time the database was closed manually by me. The only way I can get this to> >work is to insert a
[closedatabase] tag in each of the pages that the users> >hit. Then this search works as expected.> >> >When I look at the database file on disk with BBEdit, the entries are indeed> >there, since
[appendfile] writes to disk immediately. So is the> >
[closedatabase] tag always required for something like this, or am I missing a> >tag somewhere?> > I think you're using
[appendfile] where you should be using
[append].> >
[appendfile] is generally used to append data to non-db files, whereas
[append] is used to append data directly to WebCatalog db files.> > Try using
[append] instead of
[appendfile], then the changes will appear *instantly* in your search/results page, because the data will be appended to WebCatalog's RAM-cached copy of that database first, before it is written to disk.-- 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:
[input]?? (1998)
RE: New WebCatalog Version !!! (1997)
WebCatalog Builder : bug on the web site (2000)
Trouble with Netscape (1998)
Sandboxes (2004)
MAC FINDER (2001)
[WebDNA] WebDNA 7 (2011)
WCS Newbie question (1997)
Test - Please ignore (2005)
[OT] Kerio Mailserver (2003)
When to Commitdatabase? (2004)
Talk List Suggestions (1997)
Emailer again (1997)
Concatenating Form Variables (1998)
Menu to select product variations (1997)
[Q] Novice's question (1997)
WCS Newbie question (1997)
is your webDNA site 'froogle' ready ??? (2003)
[OT] What log analyzer do you use? (2000)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)