I am glad you solved it!
Enjoy your day.
Johann
--
Because experiencing your loyal love is better than life itself,
my lips will praise you. (Psalm 63:3)
Problem solved. My mistake was in thinking that the 'r' in the lambda
function referred to the C record. Of course it doesn't; we're trying to
INSERT a new C record. Instead, that 'r' refers to the parent B record. So
the lambda function should be:
lambda r : '%s' % (db.A[r.A_id].A_name)
On W
Okay; I understand. Let me explain using a simpler version, and also come
up with SQL that would do the equivalent.
Here's a simpler version. This example shows the problem, and simply uses a
grandparent table (A), a parent table (B), and a child table (C). That is,
C is a child of B, and B is
On 11 July 2012 05:27, MichaelF wrote:
> Didn't help. I now get the same error, this time in the function. Any idea
> what the error message is trying to tell me?
Unfortunately I don't have time to try and work out your logic. The error
is telling you that the process could not find the key C1
Didn't help. I now get the same error, this time in the function. Any idea
what the error message is trying to tell me?
On Tuesday, July 10, 2012 12:50:01 AM UTC-6, Johann Spies wrote:
>
> On 10 July 2012 01:09, MichaelF wrote:
>
>>
>>lambda r: '%s' % (db.I1[db.C1_2[r.C1_2].I1].Name),
>>
On 10 July 2012 01:09, MichaelF wrote:
>
>lambda r: '%s' % (db.I1[db.C1_2[r.C1_2].I1].Name),
>_and=IS_NOT_IN_DB(db(db.C1_2_3.C1_2==request.vars.C1_2), 'C1_2_3.C3'))
> db.C1_2_3.C1_2.requires=IS_IN_DB(db, 'C1_2.id',
>
> ...
> 1. Am I even allowed to have a lambda function there?
> 2. In a
In short, I'm having problems getting the drop-down value for a field in a
child-of-a-child record; I want that value to be a field from the
grandparent.
In more detail:
1. I have three 'independent' tables ('independent' in that they have no
parents). Let's call them I1, I2, and I3.
7 matches
Mail list logo