Ordering a query by a dynamic field

[Les Irvin]

Is it possible to order a query by a field produced within that same query?
This query fails at the "Order by" statement:

<CFQUERY NAME="Result" DATASOURCE="foo">
  SELECT City,
   State,
   Username,
   Longitude,
   (69.1*(longitude - 104.825814) as distance
  FROM personal
  ORDER BY distance
</cfquery>

The "distance" field is (obviously) not a field in the table being queried.

Thanks in advance for the help,
Les

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---