cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Gentry <mgen...@masslight.net>
Subject Re: Sorting strings numerically
Date Thu, 23 Sep 2010 21:17:21 GMT
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 <msabo@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
>
>
>

Mime
View raw message