Help needed: older WebCat app breaks under 4.0.1

This WebDNA talk-list message is from

2000

It keeps the original formatting. numero = 34148
interpreted = N
texte = Hi, it's me once again. To recap: I just started a developer position whereI'm learning WebCat from scratch, but I have a number of WebCat-based sitesthat seem (to me) fairly complex. Several of them have lost somefunctionality since we upgraded to 4.0 and now 4.0.1. One of the primaryproblems is the attached (below) page.The site is the front end of a subscription-only email list for news aboutthe local college (University of Arkansas Razorbacks) sports. This pageallows the business office to get a monthly look at how many peoplesubscribed that month and who they are (for records or something, I'm notsure why).startat=1 is passed to the page in the URL from the previous page. The fileitself is called accounting.tpl so the link from the previous page is:http://*/accounting.tpl&startat=1 (* being the site address)It's only returning to the point of where it should show:Displaying Records 1 - ?(there are 103 current subscribers), BUT it's only showing:Displaying Records 1 - 1and it's not displaying ANY records. Even if I search on a month where Iknow there were new subscribers, it still doesn't show any, though it doesreflect the total number of current subscribers toward the top of the page.Also, in that site's admin pages (that look like they were generated byWebCat), if I search for subscribers (on ANY criteria), it again gives meDisplaying Records 1 - 1 even though I know there are more subscribersthan that (I can crank the raw .db file open and see all the data and thereare actually 1100 or so entries, but only 103 of them are currently active,i.e., paying customers).I know the code is long and messy (I tried to clean it up as best I couldfor delivery via email), but *ANY* advice or help would be greatlyappreciated.Thanks!SteveWorking on the 4th to try and fix these problems!------------------------------------------------Steven JarvisWeb Developersjarvis@nwaonline.netMorning News of Northwest Arkansashttp://www.nwaonline.net----------------------------------------------------------------- WebCat page code --------------------------

Insiders' Edition Monthly Reconciliation

[hideif [action]=SelectMonth]



        

Month	Year
JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecember	1999 2000

[/hideif] [showif [action]=SelectMonth] [math show=F]max=100[/math][search db=subscribers.db&eqACTIVEdatarq=A&leREGDATEdatarq=[__MONTH]/31/[__YEAR]&deREGDATEsort=1&RegDatetype=date&neCOMPdatarq=T[hideif[startat]=ALL]&max=[max]&startat=[startat][/hideif]][numfound] current Insiders' Edition Subscribers for [format days_to_date %B%Y][math]{[__MONTH]/1/[__YEAR]}[/math][/format][!] ** Record Navigation ** [/!]    

Displaying records [startat] - [hideif[math][startat]+[max]-1[/math]>[numfound]] [math][startat]+[max]-1[/math][/hideif] [showif [math][startat]+[max]-1[/math]>[numfound]] [numfound][/showif] of [numfound]			Show All
[hideif [startat]=1]Start [/hideif] [showif [startat]=1] Start [/showif]	[hideif [startat]=1] <<< Previous [max][/hideif] [showif [startat]=1] <<< Previous[/showif]	[hideif [startat]>[math][numfound]-[max][/math]]Next [showif[math][startat]+[max]-1+[max][/math]<[numfound]][max][/showif] [hideif[math][startat]+[max]-1+[max][/math]<[numfound]][math][max]-[startat]-[max]-[max]+[numfound]+1[/math] [/hideif] >>>[/hideif][hideif[startat]<[math][numfound]-[max][/math]][hideif[startat]=[math][numfound]-[max][/math]] Next [max] >>>[/hideif][/hideif]	[hideif [startat]>[math][numfound]-[max][/math]] [showif[math][numfound]%[max][/math]=0] [math show=F]Last=[NumFound]-[max][/math][/showif] [showif [math][numfound]%[max][/math]!0] [mathshow=F]Last=floor([numfound]/[max])*[max]+1[/math] [/showif]End[/hideif][hideif[startat]<[math][numfound]-[max][/math]][hideif[startat]=[math][numfound]-[max][/math]]End[/hideif][/hideif]

        [founditems]     [/founditems]

#	Name	Current Month Subscriptions	Prev Month UnexpiredSubscriptions	Beginning Date	Adjustments Refunds/ Chgbacks
[index]	[Rcvr_Name]	[showif [format days_to_date%m][math]{[RegDate]}[/math][/format]=[__Month]]36.50[/showif]	[hideif [format days_to_date%m][math]{[RegDate]}[/math][/format]=[__Month]]36.50[/hideif]	[format days_to_date%d-%b][math]{[RegDate]}[/math][/format]	-

[!] ** Record Navigation ** [/!]     

Displaying records [startat] - [hideif[math][startat]+[max]-1[/math]>[numfound]] [math][startat]+[max]-1[/math][/hideif] [showif [math][startat]+[max]-1[/math]>[numfound]] [numfound][/showif] of [numfound]			Show All
[hideif [startat]=1]Start [/hideif] [showif [startat]=1] Start [/showif]	[hideif [startat]=1] <<< Previous [max][/hideif] [showif [startat]=1] <<< Previous[/showif]	[hideif [startat]=[math][numfound]-[max][/math]] [hideif[startat]>[math][numfound]-[max][/math]] Next [showif[math][startat]+[max]-1+[max][/math]<[numfound]] [max] [/showif] [hideif[math][startat]+[max]-1+[max][/math]<[numfound]][math][max]-[startat]-[max]-[max]+[numfound][/math] [/hideif]>>> [/hideif] [/hideif] [hideif[startat]<[math][numfound]-[max][/math]] Next [max] >>>[/hideif]	[hideif [startat]=[math][numfound]-[max][/math]] [hideif[startat]>[math][numfound]-[max][/math]] [showif[math][numfound]%[max][/math]=0] [math show=F]Last=[NumFound]-[max][/math][/showif] [showif [math][numfound]%[max][/math]!0] [mathshow=F]Last=floor([numfound]/[max])*[max]+1[/math] [/showif] End [/hideif] [/hideif] [hideif[startat]<[math][numfound]-[max][/math]] End [/hideif]

[/search][/showif]-------------------------------------------------------------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:

Re: REVISED: Help needed: older WebCat app breaks under 4.0.1 (John Butler 2000) Re: REVISED: Help needed: older WebCat app breaks under 4.0.1 (Joseph D'Andrea 2000) REVISED: Help needed: older WebCat app breaks under 4.0.1 (Steven Jarvis 2000) Re: Help needed: older WebCat app breaks under 4.0.1 (John Butler 2000) Help needed: older WebCat app breaks under 4.0.1 (Steven Jarvis 2000)

Hi, it's me once again. To recap: I just started a developer position whereI'm learning WebCat from scratch, but I have a number of WebCat-based sitesthat seem (to me) fairly complex. Several of them have lost somefunctionality since we upgraded to 4.0 and now 4.0.1. One of the primaryproblems is the attached (below) page.The site is the front end of a subscription-only email list for news aboutthe local college (University of Arkansas Razorbacks) sports. This pageallows the business office to get a monthly look at how many peoplesubscribed that month and who they are (for records or something, I'm notsure why).startat=1 is passed to the page in the URL from the previous page. The fileitself is called accounting.tpl so the link from the previous page is:http://*/accounting.tpl&startat=1 (* being the site address)It's only returning to the point of where it should show:Displaying Records 1 - ?(there are 103 current subscribers), BUT it's only showing:Displaying Records 1 - 1and it's not displaying ANY records. Even if I search on a month where Iknow there were new subscribers, it still doesn't show any, though it doesreflect the total number of current subscribers toward the top of the page.Also, in that site's admin pages (that look like they were generated byWebCat), if I search for subscribers (on ANY criteria), it again gives meDisplaying Records 1 - 1 even though I know there are more subscribersthan that (I can crank the raw .db file open and see all the data and thereare actually 1100 or so entries, but only 103 of them are currently active,i.e., paying customers).I know the code is long and messy (I tried to clean it up as best I couldfor delivery via email), but *ANY* advice or help would be greatlyappreciated.Thanks!SteveWorking on the 4th to try and fix these problems!------------------------------------------------Steven JarvisWeb Developersjarvis@nwaonline.netMorning News of Northwest Arkansashttp://www.nwaonline.net----------------------------------------------------------------- WebCat page code --------------------------

Insiders' Edition Monthly Reconciliation

[hideif [action]=SelectMonth]



        

Month	Year
JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecember	1999 2000

[/hideif] [showif [action]=SelectMonth] [math show=F]max=100[/math][search db=subscribers.db&eqACTIVEdatarq=A&leREGDATEdatarq=[__MONTH]/31/[__YEAR]&deREGDATEsort=1&RegDatetype=date&neCOMPdatarq=T[hideif[startat]=ALL]&max=[max]&startat=[startat][/hideif]][numfound] current Insiders' Edition Subscribers for [format days_to_date %B%Y][math]{[__MONTH]/1/[__YEAR]}[/math][/format][!] ** Record Navigation ** [/!]    

Displaying records [startat] - [hideif[math][startat]+[max]-1[/math]>[numfound]] [math][startat]+[max]-1[/math][/hideif] [showif [math][startat]+[max]-1[/math]>[numfound]] [numfound][/showif] of [numfound]			Show All
[hideif [startat]=1]Start [/hideif] [showif [startat]=1] Start [/showif]	[hideif [startat]=1] [math][startat]-[max][/math]&action=SelectMonth&__Month=[__Month]&__Year=[__Year]><<< Previous [max][/hideif] [showif [startat]=1] <<< Previous[/showif]	[hideif [startat]>[math][numfound]-[max][/math]][math][startat]+[max][/math]&action=SelectMonth&__Month=[__Month]&__Year=[__Year]>Next [showif[math][startat]+[max]-1+[max][/math]<[numfound]][max][/showif] [hideif[math][startat]+[max]-1+[max][/math]<[numfound]][math][max]-[startat]-[max]-[max]+[numfound]+1[/math] [/hideif] >>>[/hideif][hideif[startat]<[math][numfound]-[max][/math]][hideif[startat]=[math][numfound]-[max][/math]] Next [max] >>>[/hideif][/hideif]	[hideif [startat]>[math][numfound]-[max][/math]] [showif[math][numfound]%[max][/math]=0] [math show=F]Last=[NumFound]-[max][/math][/showif] [showif [math][numfound]%[max][/math]!0] [mathshow=F]Last=floor([numfound]/[max])*[max]+1[/math] [/showif]End[/hideif][hideif[startat]<[math][numfound]-[max][/math]][hideif[startat]=[math][numfound]-[max][/math]]End[/hideif][/hideif]

        [founditems] [math][index]%2[/math]=0]#e2e2e2[/showif][hideif[math][index]%2[/math]=0]#ffffcc[/hideif]>    [/founditems]

#	Name	Current Month Subscriptions	Prev Month UnexpiredSubscriptions	Beginning Date	Adjustments Refunds/ Chgbacks
[index]	[Rcvr_Name]	[showif [format days_to_date%m][math]{[RegDate]}[/math][/format]=[__Month]]36.50[/showif]	[hideif [format days_to_date%m][math]{[RegDate]}[/math][/format]=[__Month]]36.50[/hideif]	[format days_to_date%d-%b][math]{[RegDate]}[/math][/format]	-

[!] ** Record Navigation ** [/!]     

Displaying records [startat] - [hideif[math][startat]+[max]-1[/math]>[numfound]] [math][startat]+[max]-1[/math][/hideif] [showif [math][startat]+[max]-1[/math]>[numfound]] [numfound][/showif] of [numfound]			Show All
[hideif [startat]=1]Start [/hideif] [showif [startat]=1] Start [/showif]	[hideif [startat]=1] [math][startat]-[max][/math]&action=SelectMonth&__Month=[__Month]&__Year=[__Year]><<< Previous [max][/hideif] [showif [startat]=1] <<< Previous[/showif]	[hideif [startat]=[math][numfound]-[max][/math]] [hideif[startat]>[math][numfound]-[max][/math]] [math][startat]+[max][/math]&action=SelectMonth&__Month=[__Month]&__Year=[__Year]>Next [showif[math][startat]+[max]-1+[max][/math]<[numfound]] [max] [/showif] [hideif[math][startat]+[max]-1+[max][/math]<[numfound]][math][max]-[startat]-[max]-[max]+[numfound][/math] [/hideif]>>> [/hideif] [/hideif] [hideif[startat]<[math][numfound]-[max][/math]] Next [max] >>>[/hideif]	[hideif [startat]=[math][numfound]-[max][/math]] [hideif[startat]>[math][numfound]-[max][/math]] [showif[math][numfound]%[max][/math]=0] [math show=F]Last=[NumFound]-[max][/math][/showif] [showif [math][numfound]%[max][/math]!0] [mathshow=F]Last=floor([numfound]/[max])*[max]+1[/math] [/showif] End [/hideif] [/hideif] [hideif[startat]<[math][numfound]-[max][/math]] End [/hideif]

[/search][/showif]-------------------------------------------------------------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/ Steven Jarvis

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:

Weird happenings (1998) search comparison (2003) Protect vs Authenicate (1997) Applying discounts as more items are added... (1997) [WebDNA] Dates (2009) Error 11 (1996) Re:2nd WebCatalog2 Feature Request (1996) hm. (2002) Part Html part WebDNA (1997) comparison to Lasso 6 or 7 (2004) OT - SMSI complaint (2001) RE: (1997) How to set suffix mapping on IIS 5.1 ... (2004) WebMerchant and Mac Auth Hub Help Please (1999) Re:Problem (1997) [SearchString] problem with [search] context (1997) RE: [BULK] [WebDNA] WebDNA Code and HTML WYSIWYG Editors (2011) Multithreading of [replace] (1999) Date Formats (1997) WebCatalog 4.0 & Tenon iTools (2000)