What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

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:

Problem (1997) drop down menu (2000) Hiding Email Addresses (2003) Projects & Contractors (1997) Roundup function? (1997) [shownext max (1997) Banners (1997) [protect admin] (1997) standard vs intertwined multithreading (1999) japanese characters (1997) Sending an email to all )or some) email addresses int he database (1999) OT: Help Wanted (2007) encrypted query string trouble on OSX (2001) Ampersand Character (&) (1997) WebCat2b13MacPlugIn - More limits on [include] (1997) Document Contains No Data! (1997) [showif] and equality (1998) PR: WebCatalog Affiliates Program Announced -- Share the revenue for promoting WebCatalog (2000) wow (1998) cookies and [returnraw] (1997)