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:

WebCat2.0 acgi vs plugin (1997) [Very OT] Cards (2004) Price Change (1999) Maybe off topic but how to charge (1997) How does 4DWebSTAR V's cache work? (2002) Kaaaaahhhhhhhnnnnnnn! (1997) FYI: virus alert (1996) WebCatlog vs ColdFusion White Paper (2000) Assigning new CART number (1997) cookies ok ??? (2006) Putting & into a database (1999) Blowback and budgets. - OT (2000) Assigning new CART number (1997) [WebDNA] Cannot get WebDNA and MySQL working. (2015) Add a field to the error log? (1997) maximu values for sendmail! (1997) Help! WebCat2 bug (1997) trouble updating records in database (1998) Big Databases (1997) foreign languages, email, webcat (1998)