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:

creator code (1997) Calculating multiple shipping... (1997) Extended [ConvertChars] (1997) WC1.6 to WC2 date formatting (1997) [WebDNA] Listfields in an input environment (2018) Setting up WebCatalog with Retail Pro data (1996) How long does a cart last? (2002) WC Database Format (1997) WebCat2b12plugin - [search] is broken ... not! (1997) Save Word/Excel Docs to Server (2002) [WebDNA] SCOPE:, ---- was:--- Date: header on emails - timezone problem perhaps (emai) Emailer port change (1997) Need relative path explanation (1997) Mac v. NT (1998) ooops...WebCatalog [FoundItems] Problem - LONG - (1997) Multiple catalog databases and showcart (1997) WebCat, switching from NT to OSX (2003) success - serial numbers and webmerch (1997) Field name-subcategory (1997) Problems getting parameters passed into email. (1997)