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>
<td>Hist.Starts</td><td>Hist.Rejects</td><td>((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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
