Re: price totals

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 47846
interpreted = N
texte = post your code. ----- Original Message ----- From: kmac To: WebDNA Talk Sent: Tuesday, February 18, 2003 1:22 PM Subject: Re: price totals > If it's outside the [founditems] loop, it show nothing, inside it shows > 2050 instead of just 50. I'm testing with 2 records, one price =20, > the other=30. > > On Monday, February 17, 2003, at 02:21 PM, Andrew Simpson wrote: > > > 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/ > > > > > ------------------------------------------------------------- > 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)
post your code. ----- Original Message ----- From: kmac To: WebDNA Talk Sent: Tuesday, February 18, 2003 1:22 PM Subject: Re: price totals > If it's outside the [founditems] loop, it show nothing, inside it shows > 2050 instead of just 50. I'm testing with 2 records, one price =20, > the other=30. > > On Monday, February 17, 2003, at 02:21 PM, Andrew Simpson wrote: > > > 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/ > > > > > ------------------------------------------------------------- > 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:

international time (1997) forms and variables (1998) Formating Tables w/[founditems] (1998) Using Applescript to process WebCatalog functions (1998) problems with 2 tags (1997) [replaceChars] would be nice ... (1997) wrong input values? (1997) previous orders (2002) Digest Version (2000) Checking Webdna is running (2007) [WebDNA] Iso latin1 to UTF conversion db (now with file) (2013) Nested vs conditional (1997) Locking up with WebCatalog... (1997) New WebCatalog Version !!! (1997) WebCat2 several catalogs? (1997) quotes and truncating? (1997) [WebDNA] users.db (2009) Memory Leak (2000) Bill To - Ship To Information display (1997) Striping Characters (1998)