>> 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]>> | That final doesn't even show. It also says it only finds 1 record whenI *know* there are more than one of any particular searched parameter. Italways says Displaying records 1 of 1 but doesn't display the record, asthat code (the table row wrapped in a found items context) doesn't getrendered like everything else after that last [numfound] above.If I'm putting startat=1 in the URL and max is defined higher up on thepage, what could the problem be? These pages worked just fine beforeupgrading to 4.0 or 4.0.1 (I've upgraded to both). Was there some sort ofchange in the syntax of any of the above contexts between versions? I'vechecked both versions of the docs, and I can't see anything above that wouldcause a break like that.I realize it could be something somewhere else that's causing the break atthat point, but I thought I'd at least start there.Any ideas from anyone would be appreciated.Cheers,Steve> on a lucky day someone wil slog thru long code and find a problem.> > If you don't get lucky, then try to break it down to one small thing at a> time, and> then at least I would be willing to help you understand what webcat does with> some few> lines of code at a time. See if you can isolate where your page is breaking.> (I.e.> ...in the docs it says such and such tag does this... but in my page with> the> following code it does this instead... why?...) > Steven Jarvis wrote:> >> Hi, it's me once again. To recap: I just started a developer position where>> I'm learning WebCat from scratch, but I have a number of WebCat-based sites>> that seem (to me) fairly complex. Several of them have lost some>> functionality since we upgraded to 4.0 and now 4.0.1. One of the primary>> problems is the attached (below) page.>> >> The site is the front end of a subscription-only email list for news about>> the local college (University of Arkansas Razorbacks) sports. This page>> allows the business office to get a monthly look at how many people>> subscribed that month and who they are (for records or something, I'm not>> sure why).>> >> startat=1 is passed to the page in the URL from the previous page. The file>> itself 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 - 1>> >> and it's not displaying ANY records. Even if I search on a month where I>> know there were new subscribers, it still doesn't show any, though it does>> reflect 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 by>> WebCat), if I search for subscribers (on ANY criteria), it again gives me>> Displaying Records 1 - 1 even though I know there are more subscribers>> than that (I can crank the raw .db file open and see all the data and there>> are 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 could>> for delivery via email), but *ANY* advice or help would be greatly>> appreciated.>> >> Thanks!>> >> Steve>> >> Working on the 4th to try and fix these problems!>> >> ------------------------------------------------>> Steven Jarvis>> Web Developer>> sjarvis@nwaonline.net>> >> Morning News of Northwest Arkansas>> http://www.nwaonline.net>> ------------------------------------------------>> >> ----------------- WebCat page code -------------------------->> >> >> >> >> >>
>> 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]>> | >> >>>> > href=accounting.tpl?startat=ALL&action=SelectMonth&__Month=[__Month]&__Year>> =[__Year]>Show All>> | >>||
>> [hideif [startat]=1]> href=accounting.tpl?startat=1&action=SelectMonth&__Month=[__Month]&__Year=[>> __Year]>Start [/hideif] [showif [startat]=1] > color=#888888>Start [/showif]>> | >> >>>> [hideif [startat]=1] > href=accounting.tpl?startat=[math][startat]-[max][/math]&action=SelectMonth>> &__Month=[__Month]&__Year=[__Year]><<< Previous [max]>> [/hideif] [showif [startat]=1] <<< Previous>> [/showif]>> | >> >>>> [hideif [startat]>[math][numfound]-[max][/math]]> href=accounting.tpl?startat=[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] [math>> show=F]Last=floor([numfound]/[max])*[max]+1[/math] [/showif]> href=accounting.tpl?startat=[Last]&action=SelectMonth&__Month=[__Month]&__Y>> ear=[__Year]>End[/hideif][hideif>> [startat]<[math][numfound]-[max][/math]][hideif>> [startat]=[math][numfound]-[max][/math]]> color=#888888>End[/hideif][/hideif]>> | >>
# | >> Name | >> Current Month Subscriptions>> | >> Prev Month Unexpired>> Subscriptions | >> 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] >> | >> >>- | >>
>> 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]>> | >> >>> href=accounting.tpl?startat=ALL&action=SelectMonth&__Month=[__Month]&__Year>> =[__Year]>Show All>> | >>||
>> [hideif [startat]=1]> href=accounting.tpl?startat=1&action=SelectMonth&__Month=[__Month]&__Year=[>> __Year]>Start [/hideif] [showif [startat]=1] > color=#888888>Start [/showif]>> | >> >>>> [hideif [startat]=1] > href=accounting.tpl?startat=[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]] > href=accounting.tpl?startat=[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] [math>> show=F]Last=floor([numfound]/[max])*[max]+1[/math] [/showif] > href=accounting.tpl?startat=[Last]&action=SelectMonth&__Month=[__Month]&__Y>> ear=[__Year]>End [/hideif] [/hideif] [hideif>> [startat]<[math][numfound]-[max][/math]] End [/hideif]>> | >>
|
>> 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]>> | That final doesn't even show. It also says it only finds 1 record whenI *know* there are more than one of any particular searched parameter. Italways says Displaying records 1 of 1 but doesn't display the record, asthat code (the table row wrapped in a found items context) doesn't getrendered like everything else after that last [numfound] above.If I'm putting startat=1 in the URL and max is defined higher up on thepage, what could the problem be? These pages worked just fine beforeupgrading to 4.0 or 4.0.1 (I've upgraded to both). Was there some sort ofchange in the syntax of any of the above contexts between versions? I'vechecked both versions of the docs, and I can't see anything above that wouldcause a break like that.I realize it could be something somewhere else that's causing the break atthat point, but I thought I'd at least start there.Any ideas from anyone would be appreciated.Cheers,Steve> on a lucky day someone wil slog thru long code and find a problem.> > If you don't get lucky, then try to break it down to one small thing at a> time, and> then at least I would be willing to help you understand what webcat does with> some few> lines of code at a time. See if you can isolate where your page is breaking.> (I.e.> ...in the docs it says such and such tag does this... but in my page with> the> following code it does this instead... why?...) > Steven Jarvis wrote:> >> Hi, it's me once again. To recap: I just started a developer position where>> I'm learning WebCat from scratch, but I have a number of WebCat-based sites>> that seem (to me) fairly complex. Several of them have lost some>> functionality since we upgraded to 4.0 and now 4.0.1. One of the primary>> problems is the attached (below) page.>> >> The site is the front end of a subscription-only email list for news about>> the local college (University of Arkansas Razorbacks) sports. This page>> allows the business office to get a monthly look at how many people>> subscribed that month and who they are (for records or something, I'm not>> sure why).>> >> startat=1 is passed to the page in the URL from the previous page. The file>> itself 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 - 1>> >> and it's not displaying ANY records. Even if I search on a month where I>> know there were new subscribers, it still doesn't show any, though it does>> reflect 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 by>> WebCat), if I search for subscribers (on ANY criteria), it again gives me>> Displaying Records 1 - 1 even though I know there are more subscribers>> than that (I can crank the raw .db file open and see all the data and there>> are 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 could>> for delivery via email), but *ANY* advice or help would be greatly>> appreciated.>> >> Thanks!>> >> Steve>> >> Working on the 4th to try and fix these problems!>> >> ------------------------------------------------>> Steven Jarvis>> Web Developer>> sjarvis@nwaonline.net>> >> Morning News of Northwest Arkansas>> http://www.nwaonline.net>> ------------------------------------------------>> >> ----------------- WebCat page code -------------------------->> >> >> >> >> >>
>> 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]>> | >> >>>> > href=accounting.tpl?startat=ALL&action=SelectMonth&__Month=[__Month]&__Year>> =[__Year]>Show All>> | >>||
>> [hideif [startat]=1]> href=accounting.tpl?startat=1&action=SelectMonth&__Month=[__Month]&__Year=[>> __Year]>Start [/hideif] [showif [startat]=1] > color=#888888>Start [/showif]>> | >> >>>> [hideif [startat]=1] > href=accounting.tpl?startat=[math][startat]-[max][/math]&action=SelectMonth>> &__Month=[__Month]&__Year=[__Year]><<< Previous [max]>> [/hideif] [showif [startat]=1] <<< Previous>> [/showif]>> | >> >>>> [hideif [startat]>[math][numfound]-[max][/math]]> href=accounting.tpl?startat=[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] [math>> show=F]Last=floor([numfound]/[max])*[max]+1[/math] [/showif]> href=accounting.tpl?startat=[Last]&action=SelectMonth&__Month=[__Month]&__Y>> ear=[__Year]>End[/hideif][hideif>> [startat]<[math][numfound]-[max][/math]][hideif>> [startat]=[math][numfound]-[max][/math]]> color=#888888>End[/hideif][/hideif]>> | >>
# | >> Name | >> Current Month Subscriptions>> | >> Prev Month Unexpired>> Subscriptions | >> 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] >> | >> >>- | >>
>> 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]>> | >> >>> href=accounting.tpl?startat=ALL&action=SelectMonth&__Month=[__Month]&__Year>> =[__Year]>Show All>> | >>||
>> [hideif [startat]=1]> href=accounting.tpl?startat=1&action=SelectMonth&__Month=[__Month]&__Year=[>> __Year]>Start [/hideif] [showif [startat]=1] > color=#888888>Start [/showif]>> | >> >>>> [hideif [startat]=1] > href=accounting.tpl?startat=[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]] > href=accounting.tpl?startat=[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] [math>> show=F]Last=floor([numfound]/[max])*[max]+1[/math] [/showif] > href=accounting.tpl?startat=[Last]&action=SelectMonth&__Month=[__Month]&__Y>> ear=[__Year]>End [/hideif] [/hideif] [hideif>> [startat]<[math][numfound]-[max][/math]] End [/hideif]>> | >>
DOWNLOAD WEBDNA NOW!
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...