Re: [search] sort problem

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 49891
interpreted = N
texte = I don't think you can do it like you have it. The search needs to look for a field name to sort. Sounds like you may need to create a temporary db which saves the 'totals' which you can then sort. If you have v5 WebDNA you should be able to use the new [TABLE] context.Regards, Tim -- Tim Robinson IDFK Web Developments tim@idfk.com.au 114a/40 Yeo Street Neutral Bay 2089 Australia Phone +612 9908 2134 Fax +612 9908 4837> From: WJ Starck > Reply-To: (WebDNA Talk) > Date: Tue, 29 Apr 2003 22:14:06 > To: (WebDNA Talk) > Subject: [search] sort problem > > Can't wrap my brain around this one. > > This template shows the number of items ordered by SKU for a given date > range. It helps us plan ordering of product for an upcoming month. > There is a javascript popup menu that allows me to show results sorted > by SKU, Category , or Number sold. There is a variable [sortby] that is > set by the popup and has a value of either SKU, Category or NumSold: > > [search > db=../ > orders.db&neordernumdatarq=[blank]&group1field=orderdate&group2field=ord > erdate&gegroup1datarq=[startdate]&legroup2datarq=[enddate]] > [founditems] > [search db=../lineitems.db&eqordernamedatarq=[ordername]] > [founditems] > [math > show=f]total[sku]=[interpret][total[sku]][/interpret]+[quantity][/math] > [/founditems] > [/search] > [/founditems] > [/search] > > [search db=../catalog.db&neskudata=[blank][showif > [sortby]=SKU]&asskusort=1&ascategorysort=2&astitlesort=3[/ > showif][showif > [sortby]=Category]&ascategorysort=1&asskusort=2&astitlesort=3[/ > showif][showif [sortby]=NumSold]&detotal*somehow*sort=1[/showif]] > [founditems] > > [sku] > [title] > [interpret][total[sku]][/interpret] > > [/founditems] > [/search] > > Of course the [showif [sortby]=NumSold]&detotal*somehow*sort=1[/showif] > is not correct. > > Anyone have a clue how I can recode this so the [total[sku]] variable > will sort is descending fashion like I want? > > Thanks, > > > -- > > Will Starck > NovaDerm Skincare Science > http://www.novaderm.com > wjs@novaderm.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: [search] sort problem (WJ Starck 2003)
  2. Re: [search] sort problem (Tim Robinson 2003)
  3. [search] sort problem (WJ Starck 2003)
I don't think you can do it like you have it. The search needs to look for a field name to sort. Sounds like you may need to create a temporary db which saves the 'totals' which you can then sort. If you have v5 WebDNA you should be able to use the new [table] context.Regards, Tim -- Tim Robinson IDFK Web Developments tim@idfk.com.au 114a/40 Yeo Street Neutral Bay 2089 Australia Phone +612 9908 2134 Fax +612 9908 4837> From: WJ Starck > Reply-To: (WebDNA Talk) > Date: Tue, 29 Apr 2003 22:14:06 > To: (WebDNA Talk) > Subject: [search] sort problem > > Can't wrap my brain around this one. > > This template shows the number of items ordered by SKU for a given date > range. It helps us plan ordering of product for an upcoming month. > There is a javascript popup menu that allows me to show results sorted > by SKU, Category , or Number sold. There is a variable [sortby] that is > set by the popup and has a value of either SKU, Category or NumSold: > > [search > db=../ > orders.db&neordernumdatarq=[blank]&group1field=orderdate&group2field=ord > erdate&gegroup1datarq=[startdate]&legroup2datarq=[enddate]] > [founditems] > [search db=../lineitems.db&eqordernamedatarq=[ordername]] > [founditems] > [math > show=f]total[sku]=[interpret][total[sku]][/interpret]+[quantity][/math] > [/founditems] > [/search] > [/founditems] > [/search] > > [search db=../catalog.db&neskudata=[blank][showif > [sortby]=SKU]&asskusort=1&ascategorysort=2&astitlesort=3[/ > showif][showif > [sortby]=Category]&ascategorysort=1&asskusort=2&astitlesort=3[/ > showif][showif [sortby]=NumSold]&detotal*somehow*sort=1[/showif]] > [founditems] > > [sku] > [title] > [interpret][total[sku]][/interpret] > > [/founditems] > [/search] > > Of course the [showif [sortby]=NumSold]&detotal*somehow*sort=1[/showif] > is not correct. > > Anyone have a clue how I can recode this so the [total[sku]] variable > will sort is descending fashion like I want? > > Thanks, > > > -- > > Will Starck > NovaDerm Skincare Science > http://www.novaderm.com > wjs@novaderm.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/ Tim Robinson

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:

[FoundItems] solved - thanks (1997) security (https) w webcat (1999) Bug? (1997) Roundup function? (1997) Another bug to squash (WebCat2b13 Mac .acgi) (1997) EIMS Problems (1997) Help formatting search results w/ table (1997) Roundup function? (1997) Swear words (2002) Price Change (2000) Where is f2? (1997) TeaRoom (2000) Fun with dates (1997) Limit to Field Length in DB (1998) Adding muliple sku + quantities (1999) [WebDNA] sudo and shell (2010) Use of Back and Reload Buttons on ShoppingCart page? (1997) [WebDNA] anyone have a good tcpconnect post snippet? (2009) SetHeader not Working (2006) Thanks ! (1997)