tyvm Massimo exactly what I was looking for... it works perfectly and now 
the rest of my code works :)

On Monday, 5 May 2014 14:46:19 UTC+10, Massimo Di Pierro wrote:
>
> fields = db(db.address.business==4L).select().first().as_dict()
>
> On Sunday, 4 May 2014 16:59:34 UTC-5, Greg Vaughan wrote:
>>
>>
>> The following code
>>
>> fields = db(db.address.business==4L).select().as_dict()
>>
>> returns a dictionary of dictionaries
>>
>> {1L: {'street_name': 'Another', 'postcode': '4888', 'id': 1L, 'unit': 
>> False, 'building_name': '', 'city': 'Deadsville', 'lot_section': None, 
>> 'sub_building': '', 'street_suffix': None, 'unit_type': None, 
>> 'cross_type': None, 'level_floor': False, 'is_corner': False, 
>> 'unit_number': '', 'lot': False, 'business': 4L, 'add_state': 'Qld', 
>> 'floor_number': '', 'street_type': 'STREET', 'cross_name': '', 'building'
>> : False, 'street_number': 111L, 'cross_suffix': None, 'country': None, 
>> 'floor_type': None}}
>>
>> How do I return just the inner dictionary?
>>
>> {'street_name': 'Another', 'postcode': '4888', 'id': 1L, 'unit': False, 
>> 'building_name': '', 'city': 'Deadsville', 'lot_section': None, 
>> 'sub_building': '', 'street_suffix': None, 'unit_type': None, 
>> 'cross_type': None, 'level_floor': False, 'is_corner': False, 
>> 'unit_number': '', 'lot': False, 'business': 4L, 'add_state': 'Qld', 
>> 'floor_number': '', 'street_type': 'STREET', 'cross_name': '', 'building'
>> : False, 'street_number': 111L, 'cross_suffix': None, 'country': None, 
>> 'floor_type': None} 
>>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
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 [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to