Re: Conditional ODER BY Clause HELP

2016-03-21 Thread Hal.sz S.ndor
2016/03/18 12:54 ... Don Wieland: Trying to get the correct syntax on this: ORDER BY CASE WHEN tr.Placed = "X" THEN r.Division ASC, FIELD(tr.Place,"1","2","3","4","5","6","7","8","R","WD","Exc","E","S”), tr.Score DESC WHEN tr.Placed != "X" THEN tr.ride_time ASC END How does on

Conditional ODER BY Clause HELP

2016-03-19 Thread Don Wieland
Hi gang, Trying to get the correct syntax on this: ORDER BY CASE WHEN tr.Placed = "X" THEN r.Division ASC, FIELD(tr.Place,"1","2","3","4","5","6","7","8","R","WD","Exc","E","S”), tr.Score DESC WHEN tr.Placed != "X" THEN tr.ride_time ASC END How does one deal with CONDITION

Conditional ODER BY Clause HELP

2016-03-19 Thread Don Wieland
Hi gang, Trying to get the correct syntax on this: ORDER BY CASE WHEN tr.Placed = "X" THEN r.Division ASC, FIELD(tr.Place,"1","2","3","4","5","6","7","8","R","WD","Exc","E","S”), tr.Score DESC WHEN tr.Placed != "X" THEN tr.ride_time ASC END How does one deal with CONDITION