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:

Reversing [ipaddress] normalization (1998) Security for malls with different webmasters (1998) URL for Discussion Archive (1997) Founditems context returning only 1 item (1997) [HIDEIF] inside [FOUNDITEM] (1997) $Quit, $CloseDatabase corrections (1997) RE: Database Structure? (1998) error in online 3.x docs - makes it impossible to read aboutfile formats (2000) Size limit for tmpl editor ? (1997) [ConvertChars] problem (1997) [WebDNA] PayPal Instant Payment Notification Guide (2009) Multiple catalog databases and showcart (1997) PHP vs WebDNA question --calling all php gurus (2004) Tab Charactor (1997) Re1000001: Setting up shop (1997) [OT] (waaaay OT) (2004) Setting up the server (1997) WebCat2b13MacPlugIn - More limits on [include] (1997) SetLineItem LineItem where out thou? (2000) WebCat & WebTen (1997)