SQL Order By weirdness

2002-04-02 Thread Brian Scandale 

Does anyone recognize why this list seems Out of Order?

I am getting an odd result when using a calculation as the argument of an ORDER BY 
Statement...

cfquery name=Hist
  SELECT Starts, Rejects
  FROM History
  ORDER BY ((Starts-Rejects)/Starts) 
/cfquery

cfoutput query=Hist
  tr
tdHist.Starts/tdtdHist.Rejects/tdtd((Starts-Rejects)/Starts)/td
  /tr
/cfoutput

This is the result... Out of Order  Whats Up? Thanks for any insight! 

Starts  Rejects Yield
100 20  80.00%
100 5   95.00%
10  2   80.00%
10  2   80.00%
100 0   100.00%

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: SQL Order By weirdness

2002-04-02 Thread Andy Ewings 

Try putting the ((Starts-Rejects)/Starts) in your select list, give it an
alias, and order by that alias

-Original Message-
From: Brian Scandale [mailto:[EMAIL PROTECTED]]
Sent: 02 April 2002 10:33
To: CF-Talk
Subject: SQL Order By weirdness


Does anyone recognize why this list seems Out of Order?

I am getting an odd result when using a calculation as the argument of an
ORDER BY Statement...

cfquery name=Hist
  SELECT Starts, Rejects
  FROM History
  ORDER BY ((Starts-Rejects)/Starts) 
/cfquery

cfoutput query=Hist
  tr
 
tdHist.Starts/tdtdHist.Rejects/tdtd((Starts-Rejects)/Starts)/td
  /tr
/cfoutput

This is the result... Out of Order  Whats Up? Thanks for any insight! 

Starts  Rejects Yield
100 20  80.00%
100 5   95.00%
10  2   80.00%
10  2   80.00%
100 0   100.00%


__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists