yes. shame on me.
On Thursday, 10 October 2013 15:32:11 UTC-5, James Thompson wrote:
>
> Thanks.
> I assume also that:
> db.define_table('dog',Field('name'),Field('owner','reference dog'))
> should be:
> db.define_table('dog',Field('name'),Field('owner','reference person'))
> ?
>
> On Thursday, October 10, 2013 5:37:16 AM UTC-10, Massimo Di Pierro wrote:
>>
>> Oops. A typo. I fixed it in the previous message.
>>
>> On Wednesday, 9 October 2013 21:41:46 UTC-5, James Thompson wrote:
>>>
>>> I'm a little confused by:
>>> >db.dog.owner.represent = None
>>> >SQLFORM.grid(db.dog.represent==db.person.id)
>>>
>>> Why would we use db.dog.represent==db.person.id
>>> rather than db.dog.owner==db.person.id
>>> here?
>>>
>>> Thanks.
>>>
>>>
>>>
>>>
>>> On Wednesday, October 9, 2013 3:20:08 PM UTC-10, Massimo Di Pierro wrote:
>>>>
>>>> It depends. It may.
>>>>
>>>> For example given:
>>>>
>>>> db.define_table('person',Field('name'),format='%(name)s')
>>>> db.define_table('dog',Field('name'),Field('owner','reference dog'))
>>>>
>>>> if you do:
>>>>
>>>> SQLFORM.grid(db.dog.owner==db.person.id)
>>>>
>>>> it will do a recursive select for each row to find a representation of
>>>> db.dog.owner.
>>>>
>>>> You can disabled this:
>>>>
>>>> db.dog.owner.represent = None
>>>> SQLFORM.grid(db.dog.represent==db.person.id)
>>>>
>>>> or hide it
>>>>
>>>> db.dog.owner.readable = False
>>>> SQLFORM.grid(db.dog.represent==db.person.id)
>>>>
>>>> or cache it:
>>>>
>>>> db.dog.owner.represent = lambda v,r: cache.ram('person-%s'%v, lambda
>>>> v=v: v and '%(name)s'%db.person(v), None)
>>>> SQLFORM.grid(db.dog.represent==db.person.id)
>>>>
>>>> You can always add the {{=response.toolbar()}} to see all the database
>>>> queries.
>>>>
>>>>
>>>> On Wednesday, 9 October 2013 14:39:07 UTC-5, James Thompson wrote:
>>>>>
>>>>> When using SQLTABLE (or something like: {{=query_results}}) to display
>>>>> rows in a view, foreign key fields display data from their related table.
>>>>> Is web2py doing individual queries for each of these fields?
>>>>>
>>>>>
>>>>>
--
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/groups/opt_out.
