Re: [web2py] Getting drop-down value names from grandparent record

2012-07-12 Thread Johann Spies
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)

Re: [web2py] Getting drop-down value names from grandparent record

2012-07-11 Thread Johann Spies
On 11 July 2012 05:27, MichaelF mjfs...@gmail.com 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

Re: [web2py] Getting drop-down value names from grandparent record

2012-07-11 Thread MichaelF
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

Re: [web2py] Getting drop-down value names from grandparent record

2012-07-11 Thread MichaelF
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

Re: [web2py] Getting drop-down value names from grandparent record

2012-07-10 Thread Johann Spies
On 10 July 2012 01:09, MichaelF mjfs...@gmail.com 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

Re: [web2py] Getting drop-down value names from grandparent record

2012-07-10 Thread MichaelF
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 mjfs...@gmail.com wrote: lambda r: '%s' %

[web2py] Getting drop-down value names from grandparent record

2012-07-09 Thread MichaelF
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.