Re: Sorting by multiple fields
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 52068
interpreted = N
texte = You can sort it after you've returned your search results such as:[search db=game.db&geskudatarq=0&additional sorting (by date forexample)...][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 OfJustin CarrollSent: Tuesday, August 05, 2003 3:52 PMTo: WebDNA TalkSubject: Sorting by multiple fieldsI'd like to know how to sort my search for the greater of two numericfields. The db may look something like this:sku hometeam awayteam1 40 22The 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'tget. 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/
Associated Messages, from the most recent to the oldest:
You can sort it after you've returned your search results such as:[search db=game.db&geskudatarq=0&additional sorting (by date forexample)...][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 OfJustin CarrollSent: Tuesday, August 05, 2003 3:52 PMTo: WebDNA TalkSubject: Sorting by multiple fieldsI'd like to know how to sort my search for the greater of two numericfields. The db may look something like this:sku hometeam awayteam1 40 22The 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'tget. 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/
"Gary Krockover"
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:
cookies and [returnraw] (1997)
emailer (1997)
Order not created error (1997)
help with writefile (1998)
Sample Tearoom Search Error (1997)
[searchString] (1997)
File Security (1999)
WebCatalog 2.0 b 15 mac (1997)
real beginner stumped (2000)
Problem with Shared POP script (2003)
Problems with ^ could be solved with [REPLACE CHARACTERS] (1997)
Template Cache problem -- new plugin for ya' (2000)
Searching (2000)
WebCatalog for Postcards ? (1997)
Problems with SELECT MULTIPLE (1999)
Max Record length (1997)
Autonumber (2003)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
[WebDNA] ubuntu permissions can't append db (2019)
[WebDNA] SQL Search (2010)