Re: price totals

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 47843
interpreted = N
texte = 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/ 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)
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/ kmac

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:

Counting LineItems (2000) How does WebCatalog search the database? (1997) [WebDNA] Search encrypted field (2015) formula??? (2000) bug ? causes NT event log to fill (1997) Email Newsletters (2003) More Applescript (1997) Trouble Searching (1999) [WebDNA] Happy Valentine's Day! (2012) Before I Can Begin . . . (1998) Occasional crashes with $remove (1997) Locking up with WebCatalog... (1997) mem leak: webcat (2001) [OT] Form Check java problem (2003) question... no field names? (2002) [OT] Linux -> Winderz (2005) FW: 2.01 upgrade problems (1997) WebCatalog Mac 2.1b3 (1997) can webcat create directories on NT? (1997) Multiple security dbs (1997)