cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marek Šabo <ms...@buk.cvut.cz>
Subject Sorting strings numerically
Date Thu, 23 Sep 2010 10:35:51 GMT
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