sorry if you copied and pasted my solution, it had a typo. This worked for
me:
db.define_table('table1',
Field('field_1'),
format='%(field_1)s')
db.define_table('table2',
Field('field_1', 'reference table1'),
Field('field_2', 'string'),
format='%(field_1)s')
db.table2.field_1.requires = IS_IN_DB(db,db.table1.field_1,'%(field_1)s')
On Thursday, March 29, 2018 at 10:56:14 AM UTC-7, LoveWeb2py wrote:
>
> Thank you so much for your help.
>
> db.table2.field_1.requires = IS_IN_DB
> <http://localhost:8000/examples/global/vars/IS_IN_DB>(db,db.table_1.
> field_1,'%(field_1)s')
> rows = db(db.table1).select()
>
> rows shows db.table1 = 1 and not 'some_value'
>
> Unfortuantely still does not work. I am running pyDal on its own and when
> I try to query the run
>
> On Thursday, March 29, 2018 at 12:50:45 PM UTC-4, Greenpoise wrote:
>>
>> Like this, in the model:
>> db.define_table('table1',
>> Field('field_1'),
>> format='%(field_1)s')
>>
>> db.define_table('table2',
>> Field('field_1', 'reference table1'),
>> Field('field_2', 'string),
>> format='%(field_1)s')
>> db.table2.field_1.requires = IS_IN_DB
>> <http://localhost:8000/examples/global/vars/IS_IN_DB>(db,db.
>> table_1.field_1,'%(field_1)s')
>>
>>
>>
>>
>>
>> On Thursday, March 29, 2018 at 9:29:35 AM UTC-7, LoveWeb2py wrote:
>>>
>>> Do I define that in the model.py file? Can I do it before the query?
>>>
>>> On Thursday, March 29, 2018 at 12:28:02 PM UTC-4, Greenpoise wrote:
>>>>
>>>> db.table2.field_1.requires = IS_IN_DB
>>>> <http://localhost:8000/examples/global/vars/IS_IN_DB>(db,db.table_1.field_1,'%(field_1)s')
>>>>
>>>>
>>>> On Thursday, March 29, 2018 at 9:20:34 AM UTC-7, LoveWeb2py wrote:
>>>>>
>>>>>
>>>>> How can I select a foreign key and represent the value? I want to
>>>>> represent the entire group and now have to do individual queries for each
>>>>> foreign key. Is that possible?
>>>>>
>>>>> db.define_table('table1',
>>>>> Field('field_1'),
>>>>> format='%(field_1)s')
>>>>>
>>>>> db.define_table('table2',
>>>>> Field('field_1', 'reference table1'),
>>>>> Field('field_2', 'string),
>>>>> format='%(field_1)s')
>>>>>
>>>>> So in this example I would do data = db(db.table1).select() which
>>>>> returns a rows object. But the reference table1 returns an integer
>>>>> instead
>>>>> of the actual value stored in the field.
>>>>>
>>>>> How could I retrieve the value instead of the integer and is it
>>>>> possible to do it in bulk?
>>>>>
>>>>
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
