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 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/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Sorting by multiple fields ( Brian Fries 2003)
  2. Re: Sorting by multiple fields ( "Justin Carroll" 2003)
  3. Re: Sorting by multiple fields ( "Gary Krockover" 2003)
  4. Sorting by multiple fields ( Justin Carroll 2003)
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/ "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)