Hi Michael, 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 INET_ATON(Ip4Address.ipAddress) ASC Regards, -- Marek Šabo 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? > > mrg > > On Thu, Sep 23, 2010 at 6:35 AM, Marek Šabo <ms...@buk.cvut.cz> wrote: > >> Hi, >> >> 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. >> >> Regards, >> >> -- >> Marek Šabo >> >> >> >> >
