Re: Disappearing records

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 42428
interpreted = N
texte = Could this be one of those URL issues? I've seen some strange things happen when using URLs in search code. I tend to always wrap a field like your [address] inside [url][/url] regardless where it would show up in the code and regardless if you already passed it into the template using [url][/url] already.So give that a try, change all your [address] fields to [url][address][/url]Otherwise, I don't see anything wrong with my quick read through.Louis A Perosi NJ-singles.comRónán wrote:> I have a strange problem with a WebCatalog database. Records are just > disappearing. I'm hoping the list can help. The explanation is a bit > long, please bear with me. > > My client wants to keep track of redirections from his site to other > sites, and so links are in the form: > > href=redirect.tmpl?address=[url][Address][/url] > > redirect.tmpl looks like this: > > [search db=stats/referrals-by-day.db&eqDayData=[date %d/%m/%Y]] > [include increment.inc] > [/search] > [replace db=stats/referrals-by-day.db&eqDayData=[date > %d/%m/%Y]&append=T]Day=[date %d/%m/%Y]&Quantity=[math]Q[/math][/replace] > > [search db=stats/referrals-by-site.db&eqAddressData=[address]] > [include increment.inc] > [/search] > [replace > db=stats/referrals-by-site.db&eqAddressData=[address]&append=T]Address=[ > address]&Quantity=[math]Q[/math][/replace] > > [search db=stats/referrals-by-day-and-site.db&eqDayDatarq=[date > %d/%m/%Y]&eqAddressDatarq=[address]] > [include increment.inc] > [/search] > [replace db=stats/referrals-by-day-and-site.db&eqDayDatarq=[date > %d/%m/%Y]&eqAddressDatarq=[address]&append=T]Day=[date > %d/%m/%Y]&Address=[address]&Quantity=[math]Q[/math][/replace] > > [redirect [address]] > > The purpose of increment.inc is to increment the referral count, and it > looks like this: > > [ShowIf [numFound]=0] > > [/ShowIf] > > [ShowIf [numFound]!0] > [founditems] > > > [/founditems] > [/ShowIf] > > The problem occurs in the first of the three files that I write to, and > only in that one. It's a simple file, just two fields: > > Day Quantity > > What happens is that days are just disappearing at random intervals. > There will be a record for a particular day, and it will be visible in > the statistics, and then it will suddenly disappear. It doesn't get reset > to a zero quantity - it just goes. This does not happen with any of the > other databases, which is the thing that confuses me most. There is no > obvious pattern to what days disappear. > > I can recreate the daily statistics from the other two, but I would like > to get to the bottom of this. Has anyone else seen anything similar? Is > this more likely to be a bug in my code, a WebCat bug, or some problem > with the hosting server? > > Any help would be greatly appreciated, as I am stumped. > > Rónán > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Disappearing records (Gary Krockover 2002)
  2. Re: Disappearing records (Louis A Perosi 2002)
  3. Disappearing records (Rónán 2002)
Could this be one of those URL issues? I've seen some strange things happen when using URLs in search code. I tend to always wrap a field like your [address] inside [url][/url] regardless where it would show up in the code and regardless if you already passed it into the template using [url][/url] already.So give that a try, change all your [address] fields to [url][address][/url]Otherwise, I don't see anything wrong with my quick read through.Louis A Perosi NJ-singles.comRónán wrote:> I have a strange problem with a WebCatalog database. Records are just > disappearing. I'm hoping the list can help. The explanation is a bit > long, please bear with me. > > My client wants to keep track of redirections from his site to other > sites, and so links are in the form: > > href=redirect.tmpl?address=[url][Address][/url] > > redirect.tmpl looks like this: > > [search db=stats/referrals-by-day.db&eqDayData=[date %d/%m/%Y]] > [include increment.inc] > [/search] > [replace db=stats/referrals-by-day.db&eqDayData=[date > %d/%m/%Y]&append=T]Day=[date %d/%m/%Y]&Quantity=[math]Q[/math][/replace] > > [search db=stats/referrals-by-site.db&eqAddressData=[address]] > [include increment.inc] > [/search] > [replace > db=stats/referrals-by-site.db&eqAddressData=[address]&append=T]Address=[ > address]&Quantity=[math]Q[/math][/replace] > > [search db=stats/referrals-by-day-and-site.db&eqDayDatarq=[date > %d/%m/%Y]&eqAddressDatarq=[address]] > [include increment.inc] > [/search] > [replace db=stats/referrals-by-day-and-site.db&eqDayDatarq=[date > %d/%m/%Y]&eqAddressDatarq=[address]&append=T]Day=[date > %d/%m/%Y]&Address=[address]&Quantity=[math]Q[/math][/replace] > > [redirect [address]] > > The purpose of increment.inc is to increment the referral count, and it > looks like this: > > [ShowIf [numFound]=0] > > [/ShowIf] > > [ShowIf [numFound]!0] > [founditems] > > > [/founditems] > [/ShowIf] > > The problem occurs in the first of the three files that I write to, and > only in that one. It's a simple file, just two fields: > > Day Quantity > > What happens is that days are just disappearing at random intervals. > There will be a record for a particular day, and it will be visible in > the statistics, and then it will suddenly disappear. It doesn't get reset > to a zero quantity - it just goes. This does not happen with any of the > other databases, which is the thing that confuses me most. There is no > obvious pattern to what days disappear. > > I can recreate the daily statistics from the other two, but I would like > to get to the bottom of this. Has anyone else seen anything similar? Is > this more likely to be a bug in my code, a WebCat bug, or some problem > with the hosting server? > > Any help would be greatly appreciated, as I am stumped. > > Rónán > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Louis A Perosi

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:

Problems passing [SKU] with $Replace in 2.0 (1997) 2.0 Info (1997) process SSI (1998) WebCatalog for Postcards ? (1997) [searchString] (1997) WebMerchant 1.6 and https (1997) [format 40s]text[/format] doesn't work (1997) Creating a back button (1999) OT - those using fckeditor........ (2005) Solaris (2007) Problems with ^ could be solved with [REPLACE CHARACTERS] (1997) A simple email page? (1999) [listfiles] (1998) ADMIN ACCESS (1999) $Quit, $CloseDatabase corrections (1997) b12 cannot limit records returned and more. (1997) forming a SKU (1999) [ot] iBook vs. 12" PB (2004) PCS Customer submissions ? (1997) Search in 2 or more catalogs (1997)