Re: price totals

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 47852
interpreted = N
texte = The 2nd search for the TOTAL SEARCH pricetotal cannot have a '&max=X' This is what breaks the search into pages. -- Regards, Marko ------------------------------------------------------------------ Marko Bernyk - Senior System Engineer mailto:marko@conexus.com.au  http://www.conexus.com.au Technical Services, Conexus Pty Ltd, Sydney, Australia Ph 02 9975 2799 Fax 02 9975 2799          :) ------------------------------------------------------------------On Tuesday, 18 February 2003 9:36 AM, Andrew Simpson wrote: >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/ >------------------------------------------------------------- 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)
The 2nd search for the TOTAL SEARCH pricetotal cannot have a '&max=X' This is what breaks the search into pages. -- Regards, Marko ------------------------------------------------------------------ Marko Bernyk - Senior System Engineer mailto:marko@conexus.com.au  http://www.conexus.com.au Technical Services, Conexus Pty Ltd, Sydney, Australia Ph 02 9975 2799 Fax 02 9975 2799          :) ------------------------------------------------------------------On Tuesday, 18 February 2003 9:36 AM, Andrew Simpson wrote: >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/ >------------------------------------------------------------- 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/ Marko Bernyk

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:

MacAuthorize Problem (1998) [append] problem (1997) How to add product size choices to form? (1997) WebDNA Solutions --> Date format suggestions (1998) emailer setup (1997) Sorting by date (1997) deadlock (2000) Convert characters (2002) test (2006) OT - help.. (2003) OS Limitations (1998) Testing the WebCat Email List Members (2000) How to *require* a 'cl' search comparison (amongst other required comparisons) (2000) Here we go again...WebDNA - SQL- Clustering (2006) WebCatalog 4.0 has been released! (2000) Detecting/limiting connections in the developer edition ... (2004) expired beta (1997) IE-caching (1998) Some Advise needed (1997) Two submit buttons ? (1997)