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:

Ticket Ordering Question (2003) format_to_days on NT (1997) Searching multiple databases (1998) WebCat2_Mac RETURNs in .db (1997) [defined]ish (1997) Dividers (2003) [WebDNA] Help with work-around format date (2013) [WebDNA] Variable mystery (2009) Mixing and/or in searches (1998) WriteFile is there a max size? (1998) database size? (1997) Can't load tmpl files (1997) Exclamation point (1997) CSS in HTML emails? (2003) [subtotal] and others (1997) Thanks for the cool new beta! (2000) REPOST: Upgrage pricing... The future of WebCatalog is comingwith 4.0... (2000) [WebDNA] Emailer breaking format (2015) Cant open pages generated by Webcat (2004) Emailer and encryption (1997)