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:

BUG REPORT: numeric ge, le, gr & ls comparisons don't work ... (1999) Help! WebCat2 bug (1997) [WebDNA] postfix and dna (2011) RE: error count with $purchase (1997) WebCat2.0 acgi vs plugin (1997) quantity minimum problem (1997) Fun with Dates - finally resolved but.... (1997) Trouble with formula.db (1997) WebCatalog2 Feature Feedback (1996) Re[2]: Enhancement Request for WebCatalog-NT (1996) Squares instead of spaces (2001) Exclamation point (1997) WebCatalog2 Feature Feedback (1996) PCS Frames (1997) [SearchString] (1998) [WebDNA] Encrypted templates (2009) Need help... (1997) WC 4.02rc2/WebStar (2001) Thanks Grant (was: disappearing SKU (etc.) fields) (1998) Maximum characters in header? (1999)