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:
Summing fields (1997)
Pithy questions on webcommerce & siteedit (1997)
Where's Cart Created ? (1997)
Frames and WebCat (1997)
Multi-processor Mac info ... (1997)
Possible Bug in 2.0b15.acgi (1997)
showif field is number (1997)
more info on [setlineitems] (1997)
Strange Date happenings (2007)
[WebDNA] User sessions - cookies only or cookies and a sessions.db? (2016)
Emailer 1.01 bombs (1997)
NetSplat and WebCat2 (1997)
Emailer on NT not working. (1999)
pulling URL information (2003)
Polls (2003)
Errata: WCS Newbie question (1997)
IE problems persist (2004)
Multiple security dbs (1997)
Creating 404 Not Found pages (1999)
graphing (2004)