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:

Re:E-mailer application times out (1998) Dates and Math - Simple Subtraction (2004) WC2b15 - [HTMLx]...[/HTMLx] problems (1997) [WebDNA] [OT] Need to add second SSL host - what are my options? (2010) RE: [REPLACE] inside [FOUNDITEMS] (1998) What is a TAB (2003) Sorting Numbers (1997) WebCat as POP mail client? (2002) WebCat2b15MacPlugin - showing [math] (1997) Migrating to NT (1997) A sendmail warning (2005) [convertchars] (2000) Shopping Cart Deletion (2000) form data submission gets truncated (1997) WC2b15 File Corruption (1997) SIMS setup (1998) [isfolder] and [filename] (1997) 9 digit zip (2002) username = 115 (1999) [WebDNA] HTTP crashes (2010)