On Tuesday, March 5, 2013 4:37:33 PM UTC-5, Cliff Kachinske wrote:
>
> Maybe one of the DAL wizards will chime in and explain how to do this in
> the model.
>
> Until then, though, you may have to think about sorting these on the
> controller side.
>
> First, an IP address isn't a string. It's four octets, separated by dots.
> It's stored as a string, but string sorting isn't working for you.
>
> The first thing to do is break the string into its component octets,
> something like octets = ip_addy.split('.'). Now you have a list of strings
> but you still have a sorting problem because you need integers. Something
> like map(int, octets) will work.
>
> Then do
>
> rows = db(query).select(db.sometable.ip_addy, ....).as_dict()
> for row in rows: row['order_key'] = map(int, row.ip_addy.split('.') )
>
> Then go here: http://docs.python.org/2/howto/sorting.html to see how to
> sort the resulting dictionary.
>
>
>
> On Monday, March 4, 2013 5:48:41 PM UTC-5, François Delpierre wrote:
>>
>> Hi,
>>
>> How can I orderby IP address?
>> Can I write my own sort function?
>> How?
>>
>> The following code:
>> db.t_device2ip.f_ip_id.requires = IS_IN_DB(db,'t_ip.id','%(f_ip_addr)s:
>> %(f_dns_name)s',multiple=False, orderby = 't_ip.f_ip_addr')
>>
>> Sort as if IP was a string. (well in fact it is.. but that's not the
>> result I want to see..)
>>
>> Thanks,
>>
>
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
