Re: Sorting by multiple fields
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 52070
interpreted = N
texte = Gary,Thanks for the info. What I'm really wanting to do is show the highestscore of the team that won down to the lowest score of the team that won.Like this:Blue Team 50Red Team 22Green Team 40Yellow Team 26Black Team 30Orange Team 7See what I'm saying? Let me know, thanks.Justin Carroll----- Original Message ----- From: "Gary Krockover"
To: "WebDNA Talk" Sent: Tuesday, August 05, 2003 5:10 PMSubject: Re: Sorting by multiple fields> You can sort it after you've returned your search results such as:>> [search db=game.db&geskudatarq=0&additional sorting (by date for> example)...]> [founditems]> [showif [hometeam]>[awayteam]]> Home: [hometeam] Away: [awayteam]
> [/showif]> [showif [awayteam]>[hometeam]]> Away: [awayteam] Home: [hometeam]
> [/showif]> [/founditems]> [/search]>> Not sure if that will help you or not though....>> GK>>>> -----Original Message-----> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of> Justin Carroll> Sent: Tuesday, August 05, 2003 3:52 PM> To: WebDNA Talk> Subject: Sorting by multiple fields>>> I'd like to know how to sort my search for the greater of two numeric> fields. The db may look something like this:>> sku hometeam awayteam> 1 40 22>> The search would go [search db=game.db&geskudatarq=0&(what goes here?)].> It's how to sort by the greater of "hometeam" and "awayteam" that I don't> get. Thanks.>> Justin Carroll>>>> -------------------------------------------------------------> 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:
Gary,Thanks for the info. What I'm really wanting to do is show the highestscore of the team that won down to the lowest score of the team that won.Like this:Blue Team 50Red Team 22Green Team 40Yellow Team 26Black Team 30Orange Team 7See what I'm saying? Let me know, thanks.Justin Carroll----- Original Message ----- From: "Gary Krockover" To: "WebDNA Talk" Sent: Tuesday, August 05, 2003 5:10 PMSubject: Re: Sorting by multiple fields> You can sort it after you've returned your search results such as:>> [search db=game.db&geskudatarq=0&additional sorting (by date for> example)...]> [founditems]> [showif [hometeam]>[awayteam]]> Home: [hometeam] Away: [awayteam]
> [/showif]> [showif [awayteam]>[hometeam]]> Away: [awayteam] Home: [hometeam]
> [/showif]> [/founditems]> [/search]>> Not sure if that will help you or not though....>> GK>>>> -----Original Message-----> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of> Justin Carroll> Sent: Tuesday, August 05, 2003 3:52 PM> To: WebDNA Talk> Subject: Sorting by multiple fields>>> I'd like to know how to sort my search for the greater of two numeric> fields. The db may look something like this:>> sku hometeam awayteam> 1 40 22>> The search would go [search db=game.db&geskudatarq=0&(what goes here?)].> It's how to sort by the greater of "hometeam" and "awayteam" that I don't> get. Thanks.>> Justin Carroll>>>> -------------------------------------------------------------> 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/
"Justin Carroll"
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:
TEXT Variable (2003)
Disconts (2004)
Code BabelFish (was: I've been thinking) (2002)
I give up!! (1997)
Possible Macv2.1b2 Merge Bug (1997)
[WebDNA] Webdna and CMS (2012)
Error Log.db --however (1997)
Req for code: upload and append to DB (2002)
[WebDNA] HTTPS and authorization (2018)
WebDNA maxing out processor (2008)
Error: Too many nested [xxx] contexts (1997)
webcat2b12 CGI -- Date comparisons (1997)
Here we go again... was: DDEConnect not working (2006)
slowness (1998)
Tax only sometimes (2002)
Anyone have an invoicing system? (1999)
Re:E-Mailer (WebCatb15acgiMac) (1997)
[WebDNA] Getting to know ARRAY (2014)
Need formatting help (1998)
SQL statements (2002)