Re: price totals

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 47853
interpreted = N
texte = This problem will all go away with 5.0 allowing us to set session variables, but until then you could just set the value in a session cookie or pass it as a variable in the query string. On Monday, February 17, 2003, at 06:06 PM, Marko Bernyk wrote:> 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/ > ------------------------------------------------------------- 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)
This problem will all go away with 5.0 allowing us to set session variables, but until then you could just set the value in a session cookie or pass it as a variable in the query string. On Monday, February 17, 2003, at 06:06 PM, Marko Bernyk wrote:> 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/ > ------------------------------------------------------------- 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:

User .db Questions (1999) Wierd webdna problem and terminal message (2005) wierd crashes for multi-sendmails on NT (1997) Deleting Orders (1997) HomePage Caution (1997) Potential Conflicts? (1997) no global [username] or [password] displayed ... (1997) Moving encrypted fields to different boxes/platforms (2000) japanese characters (1997) [group] ? (1997) Google Web Accelerator (2005) RAM variables (1997) SMSI: Forged email addresses on the talk list ... (2002) WebTen and WebCat (1997) Another question (1997) Postdata expired from cache (2004) searchable list archive (1997) [WebDNA] Solaris version? (2008) [TEXT SECURE=T] (2000) absolute paths for databases? (1997)