Yes... Maybe they are after the table they are referenced by!!! They should
be before...
Richard
On Mon, Aug 8, 2011 at 4:47 PM, Jim Steil <j...@qlf.com> wrote:
> Eric
>
> Do you also have student and contact tables defined?
>
> -Jim
>
>
> On 8/8/2011 3:33 PM, Eric Scott wrote:
>
>> Thanks for your response, Richard and Jim. Richard, the traceback is
>> in my original message, as is the problematic part of the model code.
>> The error occurs with any view/controller -- I can't access the app at
>> all. The problem is definitely in the model and not the controller.
>> The problem occurs when I insert any code into a model with the
>> following syntax:
>>
>> field('fieldname", db.referenced_table)
>>
>> The error is revealed at the end of the traceback included in my
>> original message:
>>
>> KeyError: 'student'
>>
>> One thing that confused me when reading the web2py book was the
>> relatively brief time spend discussing foreign key relationships.
>> Every other framework I've used (CakePHP and symfony) has spent at
>> least a full chapter describing how to set up these relationships in
>> the models. This makes me feel like I'm missing something really
>> obvious. web2py has surprised me by letting me finish tasks that were
>> very time consuming in other frameworks in a few lines of code, so I'm
>> wondering if there's a really simple way to describe one-to-many and
>> many-to-many relationships in web2py that I'm missing in the
>> documentation.
>>
>> This is the syntax used for referencing many-to-one relationships in
>> Chapter 7 of the latest web2py book, so I'm not entirely sure what I'm
>> doing wrong.
>>
>> Jim, there is a many-to-one relationship between both students:users
>> and contacts:users. I'm not sure if that's what you're asking. I've
>> not seen the code you use anywhere in the web2py book (at least not
>> that I recall), so I will give it a try to see if it works.
>>
>> Thanks again,
>>
>> Eric
>>
>> On Aug 8, 3:58 pm, Richard
>> Vézina<ml.richard.vez...@**gmail.com<ml.richard.vez...@gmail.com>>
>> wrote:
>>
>>> If you send you controller and model code at least with trace back it
>>> could
>>> help to troobleshoot...
>>>
>>> Richard
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> On Mon, Aug 8, 2011 at 3:51 PM, Eric Scott<erictransla...@gmail.com**>
>>> wrote:
>>>
>>>> I'm having problems getting tables linked in web2py using reference
>>>> fields. For example, I have a model with table student and table
>>>> contact. Table auth_user contains my app's users. In db.py, under
>>>> db.define_table('auth_user') I have the following code to reference a
>>>> one-to-many relationship between users:students and users:contacts:
>>>> Field('student', db.student),
>>>> Field('contact', db.contact),
>>>> But I keep getting the following error:
>>>> Traceback (most recent call last):
>>>> File "/home/www-data/web2py/gluon/**restricted.py", line 192, in
>>>> restricted
>>>> exec ccode in environment
>>>> File "/home/www-data/web2py/**applications/teachertext/**
>>>> models/db.py",
>>>> line 61, in<module>
>>>> Field('student', db.student,
>>>> File "/home/www-data/web2py/gluon/**dal.py", line 4331, in __getattr__
>>>> return self[key]
>>>> File "/home/www-data/web2py/gluon/**dal.py", line 4325, in __getitem__
>>>> return dict.__getitem__(self, str(key))
>>>> KeyError: 'student'
>>>> I'm new to web2py (but not to frameworks) and this is my first time
>>>> referencing foreign keys in a web2py app. I'm sure I'm missing
>>>> something obvious but I'd be grateful if someone could point it out
>>>> for me.
>>>> Thank you,
>>>> Eric
>>>>
>>>
