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:

test for John (1999) Separate SSL Server (1997) Encrypting userid for email (2000) WebCatalog for Postcards ? (1997) [WebDNA] SWITCH/CASE or SHOWIF (2008) Almost a there but..bye bye NetCloak (1997) acrobat -> wc (1998) REPLACE & MAX/STARTAT parameters doesn't work? (2000) Version f1 status (1997) Ampersands in database fields? (1998) ImageMagick (2005) WebCatalog Features (1997) Virtual hosting and webcatNT (1997) Search or delete (or date or time) has bugs ... (1998) Line items in table cells (1997) Pithy questions on webcommerce & siteedit (1997) name of file (2002) WC2b15 File Corruption (1997) WebCat templates for TyphoonPro admin (1999) WebDNA Solutions ... sorry! (1997)