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'trequired.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 getreset> > 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:
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'trequired.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 getreset> > 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:
Searchable list archive (1997)
How far do [showif]s go? (1997)
Applescript, WebDNA, and PDF (1997)
snicker, snicker (1997)
Question about replacing words (1998)
more on my bbs (1997)
WebCat2 - [include] tags (1997)
[movefile] prob (2005)
Sort Order on a page search (1997)
WC2.0 Memory Requirements (1997)
Clickable maps and WebCatalog? (1996)
Encrypt/Decrypt (2007)
Firesite and [referrer] atg broke (1997)
E-Mail (1998)
my price won't move (1997)
Associative lookup style? + bit more (1997)
Lot entry (1999)
Physical Proximity searches (2000)
Job Posting (1998)
Printing a final order (1997)