I'm aware of the name method, Sam. The trouble I'm having is if I have
multiple records how could I put them in json format. I was hoping I
wouldn't have to iterate through the record and use the .name method
On Tuesday, July 14, 2015 at 2:32:36 PM UTC-4, Samuel Sowah wrote:
>
> you can do
> db(db.vendors.id==products.first().product_owner).select().first().name
> to get the name.
>
> The actual value stored in the db is the id. format helps with select
> drop-downs and viewing db records in the appadmin. As far as I know, that's
> how it works but I'd be happy to learn if there are other ways to achieve
> what you're looking for.
>
> On Tuesday, July 14, 2015 at 6:07:39 PM UTC, LoveWeb2py wrote:
>>
>> Hello,
>>
>> My goal is to represent the name instead of the field id here is my model:
>>
>> db.define_table('vendors',
>> Field('name','string'),
>> Field('vendor_location','string'),
>> format='%(name)s', migrate=True)
>>
>> db.define_table('product',
>> Field('product_code','string'),
>> Field('product_name','string'),
>> Field('product_price','string'),
>> Field('product_owner', 'reference vendors'),
>> Field('description','text'),
>> Field('image','string', label='Image Path'),
>> #Field('product_picture', 'upload',
>> uploadfield='product_picture_file'),
>> #Field('product_picture_file', 'blob'),
>> format=lambda r: '%s' % (r.product_owner.name), migrate=True)
>>
>>
>> The problem is when I try to select the field it only shows me the id and
>> not the name of the referenced record. I've seen a few of Anthony's post,
>> but I can't seem to wrap my head around what's happening.
>>
>> Here you'll see it returns the product_owner as 2L instead of the actual
>> name of the owner. Is my format/representation messed up in my model?
>>
>> In [1]: products = db(db.product.id>0).select()In [2]: products.first()
>> Out[2]: <Row {'product_owner': 2L, 'description': 'This is my product
>> description', 'image': '../static/images/image2.png', 'id': 1L,
>> 'product_price': '13.99', 'product_code': '0001', 'product_name': 'my great
>> product'}>
>>
>
--
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.
