Re: price totals

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 47849
interpreted = N
texte = do two searches. one to calculate the total and one to display the results.put it inside some showif logic to find out if the results displayed are close to the total numfound of the records so you don't do the second search on every page. ----- Original Message ----- From: kmac To: WebDNA Talk Sent: Tuesday, February 18, 2003 1:31 PM Subject: Re: price totals > How would I get this to work on the last page of results if I'm only > allowing 10 results per page? I would like a total of the search not > just results per page. > > > On Monday, February 17, 2003, at 02:22 PM, WJ Starck wrote: > > > 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/ ------------------------------------------------------------- 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)
do two searches. one to calculate the total and one to display the results.put it inside some showif logic to find out if the results displayed are close to the total numfound of the records so you don't do the second search on every page. ----- Original Message ----- From: kmac To: WebDNA Talk Sent: Tuesday, February 18, 2003 1:31 PM Subject: Re: price totals > How would I get this to work on the last page of results if I'm only > allowing 10 results per page? I would like a total of the search not > just results per page. > > > On Monday, February 17, 2003, at 02:22 PM, WJ Starck wrote: > > > 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/ ------------------------------------------------------------- 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:

syntax question, not in online refernce (1997) international time (1997) xml - amazon bug and sed q: (2004) restart needed???? (1997) Calculating Shipping charges for multiple items and qtys > 1 (1997) Help! WebCat2 bug (1997) WebCatalog Mac and cgi-bin (WebSTAR 2.0) (1997) Big Databases (1997) WC TableGrinder (1997) Help! WebCat2 bug (1997) Not reading code (1997) 2.0 Beta (1997) StoreBuilder v4.0.2 Question (2001) Long/Lat (and The ZipBurst CGI Pro) (2002) Authenticate (1997) not interpreting Q (2001) [sendmail] questions... (1997) Where's Cart Created ? (1997) Securing/hiding database file (2000) WCf2 and nested tags (1997)