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:

Firesite cache vs webcat cache (1997)Converting characters to numbers ... (1997)Multiple catalog databases and showcart (1997)credit card authorization question (1997)Pithy questions on webcommerce & siteedit (1997) WebDNA Monitor (2005)Pithy questions on webcommerce & siteedit (1997)WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)PIXO support (1997)SQL Error 22003 : Found the workaround (2001)Sending order notification by fax (1999)How much is too much? I can never remember the answer. (2002)A little syntax help (1997)two domains and one cart and database (2000)POS (2000)Ok here is a question? (1997)Re: (1998)Search results templates (1996)WebCommerce: Folder organization ? (1997)Installer AppleScript (2000)
[cname]