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:
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)