Re: Summing fields

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 10853
interpreted = N
texte = >>Let me know if it works, but I have my doubts ... the reason being that >>WebCat2 probably cannot pick up the variables from a form unless the >>'Submit' button is clicked by the user. The same concept goes for >>hyperlinks - those variables are not passed unless someone clicks the link. >> >>I think that clicking something on the page is the trigger than actually >>sends WebCat2 those variables. > >Ken's right; no CGI can possible pick up that information until _after_ >the form is submitted. HTML works that way. If you go to ClubMac you'll >see we calculate the totalWeight on an intermediate page before showing >the shipping price on the next page. Formulas.db cuts down on one extra >step, but the only way to calculate information 'live' on a single page is >to use Java or JavaScript. > hmmm this is inside a form before the submit has occurred and coltotal formats these rows and puts the in place after it has formated this 5 columns wide. This was done to format the form for input. Now I have not acted on any fields read from the data base. So it still might require the submit to occur to do what Ken wanted to do. But I knew I had seen variables declared and used prior to the submit elsewhere.Click on the Button of the Country this International Source belongs to.
[Search db=/webcatalog/control.db&cnamesort=1&cnamesdir=as&eqctypedatarq=country][founditems] [showif [math]coltotal[/math]=5] [/showif][/founditems] [/search] =============================================== Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.com =============================================== Associated Messages, from the most recent to the oldest:

[cname]
    
  1. Re: Summing fields in a search/founditems context?? (Jason Tyler 2000)
  2. Summing fields in a search/founditems context?? (Robert McPeak 2000)
  3. Re: Summing Fields (Martin Gertz Bech 1998)
  4. Re: Summing Fields (Christer Olsson 1998)
  5. Summing Fields (Wayne Morishige 1998)
  6. Re: Summing fields (grichter@panavise.com (Gary Richter) 1997)
  7. Re: Summing fields (Grant Hulbert 1997)
  8. Re: Summing fields (Kenneth Grome 1997)
  9. Re: Summing fields (grichter@panavise.com (Gary Richter) 1997)
  10. Re: Summing fields (Grant Hulbert 1997)
  11. Re: Summing fields (Kenneth Grome 1997)
  12. Re: Summing fields (Britt T. 1997)
  13. Re: Summing fields (Grant Hulbert 1997)
  14. Re: Summing fields (Kenneth Grome 1997)
  15. Re: Summing fields (Grant Hulbert 1997)
  16. Re: Summing fields (Dean Smith 1997)
  17. Re: Summing fields (Dean Smith 1997)
  18. Re: Summing fields (Grant Hulbert 1997)
  19. Summing fields (Dean Smith 1997)
>>Let me know if it works, but I have my doubts ... the reason being that >>WebCat2 probably cannot pick up the variables from a form unless the >>'Submit' button is clicked by the user. The same concept goes for >>hyperlinks - those variables are not passed unless someone clicks the link. >> >>I think that clicking something on the page is the trigger than actually >>sends WebCat2 those variables. > >Ken's right; no CGI can possible pick up that information until _after_ >the form is submitted. HTML works that way. If you go to ClubMac you'll >see we calculate the totalWeight on an intermediate page before showing >the shipping price on the next page. formulas.db cuts down on one extra >step, but the only way to calculate information 'live' on a single page is >to use Java or JavaScript. > hmmm this is inside a form before the submit has occurred and coltotal formats these rows and puts the in place after it has formated this 5 columns wide. This was done to format the form for input. Now I have not acted on any fields read from the data base. So it still might require the submit to occur to do what Ken wanted to do. But I knew I had seen variables declared and used prior to the submit elsewhere.Click on the Button of the Country this International Source belongs to.
[math]coltotal=0[/math]> [Search db=/webcatalog/control.db&cnamesort=1&cnamesdir=as&eqctypedatarq=country][founditems] [math]coltotal=coltotal+1[/math]> [showif [math]coltotal[/math]=5] [math]coltotal=0[/math]> [/showif][/founditems] [/search] =============================================== Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.com =============================================== grichter@panavise.com (Gary Richter)

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 Syntax (2002)WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)formula inside database to calculate weights (1997)ftp site no longer accepting anonymous login, so I cannotdownload (2002)Is this possible, WebCat2.0 and checkboxes (1997)problems with 2 tags (1997)Searchable WebCat (etc.) Docs ? (1997)RAM variables (1997) 2cd pair.. [math] and European Date format (2004) Autonumber Work-Around (2003)[include] error message (was:how to put/keep productcustomization info in basket?) (1998)[WebDNA] Processor Maxing out (2010)Databases (2000)advise!! (2001)[WebDNA] [listwords] seems especially slow (amongst the looping contexts) (2010)Line Breaks (2003) 404 error page issue (2006)WC2b15 File Corruption (1997)quitting (1997)WebTen and WebCat (1997)
[cname]