Re: price totals
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 47851
interpreted = N
texte = Lest we forget the newer features...[search db=my.db&eqSOMEFIELDdata=[blah]][math show=T]TheTotal=[SUM field=price][/math][/search]- ckOn Monday, February 17, 2003, at 05:48 PM, Alain Russell wrote:> If you use [text] variables for everything you donšt run into the hard > coded> limit for [math] variables ..>> Better safe than sorry.>>> Andrew->>>> I must have been asleep in class that day.>>>> What is the reason for using the [text] variable this way?>>>> Why not just do:>>>> [math show=f]pricetotal=0[/math]>> [search db=.... search string user entered]>> [founditems][math show=f]pricetotal=[pricetotal]+[price][/math][/found>> items]>> [/search]>>>> [pricetotal]>>>> ????>>>>>> -->>>> Will Starck>> NovaDerm Skincare Science>> http://www.novaderm.com>> wjs@novaderm.com>>>> On Monday, February 17, 2003, at 04: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...>>>>>>>>>>>>>>>>>>> ------------------------------------------------------------->> 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/>>--Charles Kline, PresidentRightCode, Inc.900 Briggs Road Suite 303Mount Laurel, NJ 08054Phone: 856-608-7908Fax: 856-439-0154http://www.rightcode.net-------------------------------------------------------------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:
Lest we forget the newer features...[search db=my.db&eqSOMEFIELDdata=[blah]][math show=T]TheTotal=[SUM field=price][/math][/search]- ckOn Monday, February 17, 2003, at 05:48 PM, Alain Russell wrote:> If you use [text] variables for everything you donšt run into the hard > coded> limit for [math] variables ..>> Better safe than sorry.>>> Andrew->>>> I must have been asleep in class that day.>>>> What is the reason for using the [text] variable this way?>>>> Why not just do:>>>> [math show=f]pricetotal=0[/math]>> [search db=.... search string user entered]>> [founditems][math show=f]pricetotal=[pricetotal]+[price][/math][/found>> items]>> [/search]>>>> [pricetotal]>>>> ????>>>>>> -->>>> Will Starck>> NovaDerm Skincare Science>> http://www.novaderm.com>> wjs@novaderm.com>>>> On Monday, February 17, 2003, at 04: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...>>>>>>>>>>>>>>>>>>> ------------------------------------------------------------->> 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/>>--Charles Kline, PresidentRightCode, Inc.900 Briggs Road Suite 303Mount Laurel, NJ 08054Phone: 856-608-7908Fax: 856-439-0154http://www.rightcode.net-------------------------------------------------------------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/
Charles Kline
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:
Creating main- and sub-category search (1997)
Another question about credit cards (1997)
[searchString] (1997)
color and size options / ARCHIVES (1997)
AOL and webcat (1998)
WebCatalog 2.0 b 15 mac (1997)
How much is too much? I can never remember the answer. (2002)
Weird cart problem (webcat 2.x) (2000)
SIMS setup (1998)
WebCat2b12 CGI Mac - [shownext] problem (1997)
Webstar v (2001)
form population (1998)
WebCommerce: Folder organization ? (1997)
Close-to Comparison Code (1998)
WebCat B13 Mac CGI -- Frames question (1997)
FEA REQ: One .hdr, multiple .db's (2003)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
WebCat2b12plugin - [search] is broken ... not! (1997)
creating an index based on first letter of word inspecific field in database (2002)
can WC render sites out? (1997)