Re: Disappearing records
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 42428
interpreted = N
texte = 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] regardlesswhere it would show up in the code and regardless if you already passedit 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 PerosiNJ-singles.comRó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/
Associated Messages, from the most recent to the oldest:
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] regardlesswhere it would show up in the code and regardless if you already passedit 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 PerosiNJ-singles.comRó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/
Louis A Perosi
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:
creator code (1997)
Calculating multiple shipping... (1997)
Extended [ConvertChars] (1997)
WC1.6 to WC2 date formatting (1997)
[WebDNA] Listfields in an input environment (2018)
Setting up WebCatalog with Retail Pro data (1996)
How long does a cart last? (2002)
WC Database Format (1997)
WebCat2b12plugin - [search] is broken ... not! (1997)
Save Word/Excel Docs to Server (2002)
[WebDNA] SCOPE:, ---- was:--- Date: header on emails - timezone problem perhaps (emai)
Emailer port change (1997)
Need relative path explanation (1997)
Mac v. NT (1998)
ooops...WebCatalog [FoundItems] Problem - LONG - (1997)
Multiple catalog databases and showcart (1997)
WebCat, switching from NT to OSX (2003)
success - serial numbers and webmerch (1997)
Field name-subcategory (1997)
Problems getting parameters passed into email. (1997)