[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: K-fest for oz?

Jonno Downes wrote:


SELECT criteria_description FROM VenueSelectionCriteria ORDER BY
 CASE
 WHEN criteria_description="table space" THEN 1
 WHEN criteria_description="good audio visuals" THEN 2
 WHEN criteria_description="comfy seating" THEN 3
END ASC


I give up - SQL????

--
|              Mark McDougall                | "Electrical Engineers do it
|  <http://members.iinet.net.au/~msmcdoug>   |   with less resistance!"