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 <msab..uk.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
>
>
>
This archive was generated by hypermail 2.0.0 : Thu Sep 23 2010 - 21:18:12 UTC