Re: [search] sort problem
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 49902
interpreted = N
texte = Hmm. Difficult this [table] tag is.Is this the proper syntax? I don't get any results displayed...[search db=../catalog.db&neskudata=[blank]] [table name=productsort&fields=sku,category,title,numsold] [founditems] [sku] [title] [category] [interpret][total[sku]][/interpret] [/founditems] [/table] [/search] [search table=productsort[showif [sortby]=SKU]&asskusort=1&ascategorysort=2&astitlesort=3[/ showif][showif [sortby]=Category]&ascategorysort=1&asskusort=2&astitlesort=3[/ showif][showif [sortby]=NumSold]&denumsoldsort=1[/showif]] [founditems]
| [sku] | [title] | [category] | [numsold] |
[/founditems] [/search]???-Will On Tuesday, April 29, 2003, at 10:37 PM, Tim Robinson wrote:> 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=o >> rd >> 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/ > > --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:
Hmm. Difficult this [table] tag is.Is this the proper syntax? I don't get any results displayed...[search db=../catalog.db&neskudata=[blank]] [table name=productsort&fields=sku,category,title,numsold] [founditems] [sku] [title] [category] [interpret][total[sku]][/interpret] [/founditems] [/table] [/search] [search table=productsort[showif [sortby]=SKU]&asskusort=1&ascategorysort=2&astitlesort=3[/ showif][showif [sortby]=Category]&ascategorysort=1&asskusort=2&astitlesort=3[/ showif][showif [sortby]=NumSold]&denumsoldsort=1[/showif]] [founditems] | [sku] | [title] | [category] | [numsold] |
[/founditems] [/search]???-Will On Tuesday, April 29, 2003, at 10:37 PM, Tim Robinson wrote:> 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=o >> rd >> 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/ > > --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:
Only charge card when product shipped ? (1997)
[shell] (2003)
Next X hits (1996)
Missing from Docs [folderName] (1997)
about this server and links to who (1997)
Nested vs conditional (1997)
2.0.1: Shopping Carts deleted after 1 hour (1997)
taxTotal, grandTotal (1997)
RE: [WebDNA] Suddenly, lots of WebDNA problems with FastCGI (2013)
error No such file (2001)
Databases inside [SHOWIF] (1998)
Show if time tags (1997)
multiple databases (1997)
Webcat Manual and TeaRoom Examples Uses Different Examples. (1997)
Online reference (1997)
Mass Mail (2000)
State Coalition Approves Internet Sales Tax Plan (2002)
Forms Search Questions (1997)
How to best sort in a pre-defined item-by-item order ... (2003)
debug file format.... (1999)