Re: Help needed: older WebCat app breaks under 4.0.1

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 34155
interpreted = N
texte = Steven, 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?...)-John 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] > >

>
> > > > > > > > > > > > > > > > > >
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/ 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)
  4. Re: Help needed: older WebCat app breaks under 4.0.1 (John Butler 2000)
  5. Help needed: older WebCat app breaks under 4.0.1 (Steven Jarvis 2000)
Steven, 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?...)-John 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] > >

>
> > > > > > > > > > > > > > > > > >
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/ John Butler

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:

HTML Editors (1997) WebDNA Quick Reference (Reserved Words) (2000) Multiple Pulldowns (1997) RE: OK, here goes... (1997) Slightly OT: [sendmail] help (2003) Sorting problem (2002) user/password validation (1998) createfolder not behaving as expected (1999) FAX orders (1996) Re:Version 2.0 and 1.6 simultaneous (1997) Need some Java Script Code (2003) trouble updating records in database (1998) UPS Shipping Docs (Where To Go) (1999) ShowNext and random sort (1998) Hello world ... (2002) MacWEEK article help needed (1996) Missing Cart Information (2003) [WebDNA] why is the webdna.us site slow? (sometimes?) (2011) unsubscribe (1997) Whats going on with my SERIAL NUMBER??? (1998)