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:

Applescript, WebDNA, and PDF (1997) NT Manual (1997) taxTotal (1997) unique ascending numbers (2003) Emailer errors (1997) WEBCAT with SQL backend. Help please! (2000) What are SMSI's upgrade policies? (2003) Emailer (WebCat2) (1997) Instructions for Digest (1997) setting taxable to true (1997) rotating thumbnails (1997) Cancel Subscription (1996) Server slowing down. (1997) path hierarchy notation (1998) Linux problems (2000) math with multiple [founditems] (1999) Webcat Manual and TeaRoom Examples Uses Different Examples. (1997) 'does not contain' operator needed ... (1997) carriage returns in data (1997) WML (2000)