REVISED: Help needed: older WebCat app breaks under 4.0.1

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 34159
interpreted = N
texte = John, et al.,It was sort of a hail Mary plea for help, as I thought there might be something incredibly obvious I was missing from inexperience. I seem to have it narrowed down some now. If I view source on the rendered page, it stops producing HTML (no ending body tag, no NOTHING) after this point.[SNIP] >> [!] ** Record Navigation ** [/!] >> >> >> That final doesn't even show. It also says it only finds 1 record when I *know* there are more than one of any particular searched parameter. It always says Displaying records 1 of 1 but doesn't display the record, as that code (the table row wrapped in a found items context) doesn't get rendered like everything else after that last [numfound] above.If I'm putting startat=1 in the URL and max is defined higher up on the page, what could the problem be? These pages worked just fine before upgrading to 4.0 or 4.0.1 (I've upgraded to both). Was there some sort of change in the syntax of any of the above contexts between versions? I've checked both versions of the docs, and I can't see anything above that would cause a break like that.I realize it could be something somewhere else that's causing the break at that 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 -------------------------- >> >> >> >> >> >> Insiders' Edition Monthly Reconciliation >> >> >> >>

Insiders' Edition Monthly Reconciliation

>> >> [hideif [action]=SelectMonth] >> >>

>> >> >> >>
>> 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] >>
>> >> >> >> >> >> >> >> >> >> >> >> >> >> >>
MonthYear
>> >> >> >>
>> >>
>> >> >> >> [/hideif] >> >> >> >> [showif [action]=SelectMonth] >> [math show=F]max=100[/math] >> [search >> db=subscribers.db&eqACTIVEdatarq=A&leREGDATEdatarq=[__MONTH]/31/[__YEAR]&deR >> EGDATEsort=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] >> >> > 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] >>
>> >> >> >> >> >> >> >> >> >> >> >> [founditems] >> > [math][index]%2[/math]=0]#ffffcc[/hideif]> >> >> >> >> >> >> >> >> >> >> >> [/founditems] >>
#
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]  >> -
>> >>
>> >> [!] ** 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] >> > 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] >>
>> [/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/ > > > ------------------------------------------------------------- > 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 Web Developer sjarvis@nwaonline.netThe Morning News of Northwest Arkansas NWAOnline http://www.nwaonline.net/ ----------------------------------------------------------------------------------------------------- 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:

    
  1. Re: REVISED: Help needed: older WebCat app breaks under 4.0.1 (John Butler 2000)
  2. Re: REVISED: Help needed: older WebCat app breaks under 4.0.1 (Joseph D'Andrea 2000)
  3. REVISED: Help needed: older WebCat app breaks under 4.0.1 (Steven Jarvis 2000)
John, et al.,It was sort of a hail Mary plea for help, as I thought there might be something incredibly obvious I was missing from inexperience. I seem to have it narrowed down some now. If I view source on the rendered page, it stops producing HTML (no ending body tag, no NOTHING) after this point.[SNIP] >> [!] ** Record Navigation ** [/!] >> >> >> That final doesn't even show. It also says it only finds 1 record when I *know* there are more than one of any particular searched parameter. It always says Displaying records 1 of 1 but doesn't display the record, as that code (the table row wrapped in a found items context) doesn't get rendered like everything else after that last [numfound] above.If I'm putting startat=1 in the URL and max is defined higher up on the page, what could the problem be? These pages worked just fine before upgrading to 4.0 or 4.0.1 (I've upgraded to both). Was there some sort of change in the syntax of any of the above contexts between versions? I've checked both versions of the docs, and I can't see anything above that would cause a break like that.I realize it could be something somewhere else that's causing the break at that 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 -------------------------- >> >> >> >> >> >> Insiders' Edition Monthly Reconciliation >> >> >> >>

Insiders' Edition Monthly Reconciliation

>> >> [hideif [action]=SelectMonth] >> >>

>> >> >> >>
>> 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] >>
>> >> >> >> >> >> >> >> >> >> >> >> >> >> >>
MonthYear
>> >> >> >>
>> >>
>> >> >> >> [/hideif] >> >> >> >> [showif [action]=SelectMonth] >> [math show=F]max=100[/math] >> [search >> db=subscribers.db&eqACTIVEdatarq=A&leREGDATEdatarq=[__MONTH]/31/[__YEAR]&deR >> EGDATEsort=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] >> >> > 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] >>
>> >> >> >> >> >> >> >> >> >> >> >> [founditems] >> [math][index]%2[/math]=0]#e2e2e2[/showif][hideif >> [math][index]%2[/math]=0]#ffffcc[/hideif]> >> >> >> >> >> >> >> >> >> >> >> [/founditems] >>
#
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]  >> -
>> >>
>> >> [!] ** 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] >> > 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] >>
>> [/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/ > > > ------------------------------------------------------------- > 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 Web Developer sjarvis@nwaonline.netThe Morning News of Northwest Arkansas NWAOnline http://www.nwaonline.net/ ----------------------------------------------------------------------------------------------------- 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:

Major bug report on rootbeer (1997) webmerch and serials - almost there (1997) WCS Newbie question (1997) Smart caching problems with 2.1b3? (1997) Date/Time format problems (1997) suffix mapping for NT? (1997) problems with 2 tags (1997) Sample Tearoom Search Error (1997) Searchable WebCat (etc.) Docs ? (1997) GuestBook example (1997) WebDNA-Talk Digest mode broken (1997) [WebDNA] Security Images (Captcha) (2008) payflowpro problem #2 (2003) ShoppingCart removal (2002) pop up building with summarize (1998) Add a field to the error log? (1997) Updating Prices in Online Database (1999) Mozilla/4. and Browser Info.txt (1997) More on the email templates (1997) problem (how to mark orders as 'opened') (1998)