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 in the 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:

    
  1. Re: Search context not finding recent entries (Gil Poulsen 1998)
  2. Re: Search context not finding recent entries (PCS Technical Support 1998)
  3. Search context not finding recent entries (Gil Poulsen 1998)
Yeah, that did it. I think I already knew that, but I went ahead and put in the 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)