[search] sort problem

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 49890
interpreted = N
texte = 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/ 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)
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/ WJ Starck

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:

WebCat2final1 crashes (1997) Location of Browser Info.txt file (1997) Math (1997) Emailer not working (1998) passing username and password (2000) Encrypt/Decrypt (2007) again (1998) [OT] Gateway and Merchant Fees! (2006) Multiple catalog databases and showcart (1997) Excuse me for a second (2000) spawn (1998) Error Lob.db records error message not name (1997) Online reference (1997) Separate SSL Server (1997) [isfile] ? (1997) Fun with dates (1997) taxTotal, grandTotal (1997) WebCat2b12--[searchstring] bug (1997) URL for Discussion Archive (1997) WebCommerce: Folder organization ? (1997)