Re: price totals

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 47842
interpreted = N
texte = yeah - you need to output [pricetotal] to the screen.the founditems will just loop each of your records adding the price from the database to the running total which is price total.outside the founditems, the price total should equal the summ of all the prices that were returned in the search. hopefully----- Original Message ----- From: kmac To: WebDNA Talk Sent: Tuesday, February 18, 2003 1:14 PM Subject: Re: price totals > Andrew, I assume to display the total I need to use [pricetotal] > because i see nothing in the [founditems] until I use that variable. It > shows 2050 for 2 items one a 20 and one a 30. I must be doing > something wrong. > > > On Monday, February 17, 2003, at 02:05 PM, Andrew Simpson wrote: > > > [text]pricetotal=0[/text] > > [search db=.... search string user entered] > > [founditems][text]pricetotal=[math][pricetotal]+[price][/math][/ > > text][/found > > items] > > [/search] > > > > long way... > > > > ----- Original Message ----- > > From: kmac > > To: WebDNA Talk > > Sent: Tuesday, February 18, 2003 12:59 PM > > Subject: price totals > > > > > >> Hi group, probably a dumb question, but I haven't done this before. > >> > >> I have a small db that has the cost of each record entered. It's not > >> store, it just has a price entered for the record. > >> If a user does a search and get a set amount of records I would like > >> the total of the records found displayed at the bottom of the page. > >> > >> What is my best approach.? I used the field name [price] for each > >> record. > >> > >> TIA > >> > >> Ken > >> > >> > >> ------------------------------------------------------------- > >> 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://webdna.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://webdna.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://webdna.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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: price totals (Charles Kline 2003)
  2. Re: price totals (Marko Bernyk 2003)
  3. Re: price totals (Charles Kline 2003)
  4. Re: price totals (Alain Russell 2003)
  5. Re: price totals (Andrew Simpson 2003)
  6. Re: price totals (kmac 2003)
  7. Re: price totals (kmac 2003)
  8. Re: price totals (Andrew Simpson 2003)
  9. Re: price totals (Andrew Simpson 2003)
  10. Re: price totals (WJ Starck 2003)
  11. Re: price totals (kmac 2003)
  12. Re: price totals (Andrew Simpson 2003)
  13. Re: price totals (kmac 2003)
  14. Re: price totals (Andrew Simpson 2003)
  15. price totals (kmac 2003)
yeah - you need to output [pricetotal] to the screen.the founditems will just loop each of your records adding the price from the database to the running total which is price total.outside the founditems, the price total should equal the summ of all the prices that were returned in the search. hopefully----- Original Message ----- From: kmac To: WebDNA Talk Sent: Tuesday, February 18, 2003 1:14 PM Subject: Re: price totals > Andrew, I assume to display the total I need to use [pricetotal] > because i see nothing in the [founditems] until I use that variable. It > shows 2050 for 2 items one a 20 and one a 30. I must be doing > something wrong. > > > On Monday, February 17, 2003, at 02:05 PM, Andrew Simpson wrote: > > > [text]pricetotal=0[/text] > > [search db=.... search string user entered] > > [founditems][text]pricetotal=[math][pricetotal]+[price][/math][/ > > text][/found > > items] > > [/search] > > > > long way... > > > > ----- Original Message ----- > > From: kmac > > To: WebDNA Talk > > Sent: Tuesday, February 18, 2003 12:59 PM > > Subject: price totals > > > > > >> Hi group, probably a dumb question, but I haven't done this before. > >> > >> I have a small db that has the cost of each record entered. It's not > >> store, it just has a price entered for the record. > >> If a user does a search and get a set amount of records I would like > >> the total of the records found displayed at the bottom of the page. > >> > >> What is my best approach.? I used the field name [price] for each > >> record. > >> > >> TIA > >> > >> Ken > >> > >> > >> ------------------------------------------------------------- > >> 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://webdna.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://webdna.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://webdna.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://webdna.smithmicro.com/ Andrew Simpson

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:

[OT] What's a 412 error? (2003) [ot] Webserver monitoring (2001) Email notification to one of multiple vendors ? (1997) Trigger action Quandry (2002) WebCatalog NT beta 18 now available (1997) [WebDNA] postfix and dna (2011) Checking two required fields (1998) WebCat2b15MacPlugIn - [authenticate] not [protect] (1997) Part Html part WebDNA (1997) Webten + Webcat running smooth (1998) WebCatalog 4.0.1b2 is now available (2000) pop up menu's (1998) No luck with taxes (1997) apostrophe in search item (1997) AmEx, shipping (2000) Fwd: Problems with Webcatalog Plug-in (1997) Setting up shop (1997) price carry over (1997) [Q] Novice's question (1997) Seeking NT Mail Server Experiences (1998)