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:
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)