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 afield name to sort. Sounds like you may need to create a temporary db whichsaves the 'totals' which you can then sort. If you have v5 WebDNA you shouldbe able to use the new [TABLE] context.Regards,Tim-- Tim RobinsonIDFK Web Developmentstim@idfk.com.au114a/40 Yeo StreetNeutral Bay 2089AustraliaPhone +612 9908 2134Fax +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:
I don't think you can do it like you have it. The search needs to look for afield name to sort. Sounds like you may need to create a temporary db whichsaves the 'totals' which you can then sort. If you have v5 WebDNA you shouldbe able to use the new [table] context.Regards,Tim-- Tim RobinsonIDFK Web Developmentstim@idfk.com.au114a/40 Yeo StreetNeutral Bay 2089AustraliaPhone +612 9908 2134Fax +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:
Too many webcat comments. [WAS- Large founditems loops] (2000)
Lookup Notfound (1998)
[WebDNA] Error: template... (2009)
Is it possible to pause or wait a process (2000)
3 card formulas! (1999)
Robert Minor duplicate mail (1997)
Setting up shop (1997)
Using Cookie for client specific info? (1997)
Purchase Plugin Missing (1996)
OT-Load balance (2004)
emailer (1997)
ThreadMem ignored? (1998)
Problems appending to database (1997)
WebCat editing, SiteGuard & SiteEdit (1997)
Browser Info.txt (1997)
OT : Site speed feedback (2002)
[SQL] & ODBC on Mac - Reposted (2000)
locking variables? (2000)
webten vs. webstar (1998)
seeking new isp (2000)