[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 StarckNovaDerm Skincare Sciencehttp://www.novaderm.comwjs@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:
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 StarckNovaDerm Skincare Sciencehttp://www.novaderm.comwjs@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)