Complex math in HQL

[Bear Bibeault]

I have a table named LOCATIONS mapped to an entity named Location.

The SQL that works for me is as follows:

select ZipCode,sqrt( square(:latitudeValue - Latitude) + square(:longitudeValue - Longitude)) as distance from LOCATIONS order by distance

which, when I limit the returned list to single value, gives me the record I need.

What's the HQL equivalent? I'm just used to referencing entity properties...

[David O'Meara]

just as an aside, it may be easier on the database (but check first) if you omit the sqrt in the SQL/HQL and apply it to the code afterwards.

[Bear Bibeault]

DB is SQL Server (if it makes nay difference).

[Mark Spritzler]

Sorry, I posted a possible HQL in your other thread.

You can always also just stick with the SQL.

I like the HQL version though. Check your other thread.

Thanks

Mark

[Bear Bibeault]

Thanks Mark. I'll close this one to prevent duplication.