Re: Disappearing records

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 42433
interpreted = N
texte = Did you try:[search db=stats/referrals-by-day.db&eqDayDatarq=[date %d/%m/%Y]]and for the replace: [replace db=stats/referrals-by-day.db&eqDayDatarq=[date %d/%m/%Y](note the rq at the end of eqDayData).Maybe it's replacing too many records because the search and replace aren't required.GK> 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.com > > Ró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/ ------------------------------------------------------------- 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)
Did you try:[search db=stats/referrals-by-day.db&eqDayDatarq=[date %d/%m/%Y]]and for the replace: [replace db=stats/referrals-by-day.db&eqDayDatarq=[date %d/%m/%Y](note the rq at the end of eqDayData).Maybe it's replacing too many records because the search and replace aren't required.GK> 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.com > > Ró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/ ------------------------------------------------------------- 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/ Gary Krockover

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:

My Eyes doth deceive me (2002) Need some Java Script Code (2003) Updating a database once per day - An example (1998) Multiple Pulldowns (1997) 4.5.1 on Panther? (2004) Some Questions (1997) DON'T use old cart file! (1997) One per customer (2000) hierarchy question... (2000) Bug? (1997) [WebDNA] Corrupted Db that Table-Search other db's (2011) Deleting Cookie Problems (2007) READFILE command? (1998) WebCat & WebTen (1997) WC2b12: Yes, Formulas.db is for real (1997) Refreshing Javascript (2001) 4.0x on production server (2000) Almost There But? WebCat Keeps Changing Cart Numbers onMe! (2002) Single Link browsing (1997) tracking no. of downloads (2006)