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 Engineermailto:marko@conexus.com.au http://www.conexus.com.auTechnical Services, Conexus Pty Ltd, Sydney, AustraliaPh 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:
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 Engineermailto:marko@conexus.com.au http://www.conexus.com.auTechnical Services, Conexus Pty Ltd, Sydney, AustraliaPh 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)