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:
The IBC root beer has arrived! (1997)
Nested search (1997)
[WebDNA] Databases not staying open (2010)
Location of Webcat site in folder hierarchy (1997)
LOOP and IF statements (1997)
Webcatalog quitting (1997)
Change [cart] date (2002)
HELP WITH DATES (1997)
It just Does't add up!!! (1997)
Multiple prices (1997)
Remove a Field from a DB (2007)
IIS4b2 and WebCatalog b19 (1997)
WebCat2 Append problem (B14Macacgi) (1997)
Non-SGML Characters and databases (2004)
Protecting webdelivery (1997)
Cart ID Duplication (2001)
relational db question (2002)
# of real domains on 1 web server (1997)
Dummy Credit Card Number for debug? (1997)
Windows 95/NT tip of the month (1998)