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 highest score of the team that won down to the lowest score of the team that won. Like this: Blue Team 50 Red Team 22 Green Team 40 Yellow Team 26 Black Team 30 Orange Team 7 See 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 PM Subject: 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:

    
  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)
Gary, Thanks for the info. What I'm really wanting to do is show the highest score of the team that won down to the lowest score of the team that won. Like this: Blue Team 50 Red Team 22 Green Team 40 Yellow Team 26 Black Team 30 Orange Team 7 See 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 PM Subject: 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)