|| at Sep 23, 2010 at 9:43 pm
sorry, my first post was probably confusing.
I could do it programmatically but I want to know if it is possible with
cayenne sorting engine, paraphrased, Can I modify sort order property
for cayenne somehow, e.g. as MySQL function INET_ATON()?
Meanwhile I can create a template query:
SELECT ipAddress FROM Ip4Address ORDER BY
On 09/23/2010 11:17 PM, Michael Gentry wrote:
Hi Marek, are you asking if the database can do it or are you wanting
to do it in your application's memory with (or without) Cayenne?
On Thu, Sep 23, 2010 at 6:35 AM, Marek Šabo wrote:
I would like to know if there is a way to sort string(varchar) columns
numerically. I know it's bad design but legacy database can't be changed
atm. I'm talking about IPv4 columns, which we need to sort. ( In new model I
aim to store them as integers and map extra column in cayenne with mysql
INET_ATON(), hope it will work.)
I tried to add "+0" to sort order property, but it failed parsing.