Thanks Batman,
I will give this a try now.
Simon
On Wednesday, 7 November 2012 17:24:34 UTC, Niphlod wrote:
>
> "english logic": a chart named 'abc' is mine if there is a record in the
> 'user_chart' table whose id_user is my user_id and has a chart_id equal to
> the id of the 'chart' table whose chartName is 'abc'
>
> DAL syntax:
> db(
> (db.user_chart.id_user == auth.user_id) & ##all charts of the user
> (db.chart.chartName == 'abc') & ##all charts named 'abc'
> (db.user_chart.id_chart == db.chart.id) ##the actual relation
> ).select()
>
>
>
>
> On Wednesday, November 7, 2012 5:30:42 PM UTC+1, Simon Carr wrote:
>>
>> Hi All,
>>
>> I have these 3 tables among others
>>
>> db.define_table('workbook',
>> Field('path',requires=[IS_NOT_EMPTY(),IS_NOT_IN_DB(db,'workbook.path')]),
>> Field('title',requires=IS_NOT_EMPTY()),
>> format="%(title)s",
>> )
>>
>>
>> db.define_table('chart',
>> Field('chartName'),
>> Field('id_workbook',db.workbook),
>> Field('worksheet'),
>> Field('file','upload'),
>> format="%(id_workbook)s %(chartName)s",
>> )
>>
>> db.define_table('user_chart',
>>
>> Field('id_user',db.auth_user,writable=False,readable=False,default=auth.user_id),
>> Field('id_chart','reference chart'),
>> Field('title'),
>> Field('description','text'),
>> format="%(title)s",
>> )
>>
>> I have setup a function in my modal
>>
>> def is_my_chart(chartname):
>> if db((db.user_chart.id_user == auth.user_id) &
>> (db.user_chart.id_chart.chartName == chartname)).count() > 0:
>> return True
>> else:
>> return False
>>
>> But I get the following error
>>
>> AttributeError: 'Field' object has no attribute 'chartName'
>>
>>
>> How do I fetch the fields out of a joined table?
>>
>> Thanks
>> Simon
>>
>>
--
