The secret of how to be miserable is to constantly expect things are going to happen the way that they are "supposed" to happen.
You can have faith, which carries the understanding that you may be disappointed. Then there's being a willfully-blind idiot, which virtually guarantees it.
Bear Bibeault wrote:Thanks guys, that was helpful. I've got it down to the following SQL query:
select ZipCode,sqrt( square(:latitudeValue - Latitude) + square(:longitudeValue - Longitude)) as distance from LOCATIONS order by distance
which, limited to a single result, gives me the record I need.
Now, I need to do this in HQL.
Did you see how Paul cut 87% off of his electric heat bill with 82 watts of micro heaters? |