Model:
db.define_table('movie',
Field('title','string'),
Field('api_id', 'string'),
Field('average_rating', 'double'),
Field('released', 'integer'),
Field('mpaa_rating', 'string'),
Field('synopsis', 'text'),
Field('short_synopsis', 'text'),
Field('created', 'datetime','datetime', default=request.now),
Field('modified', 'datetime','datetime', default=request.now),
format = '%(title)s')
db.define_table('person',
Field('name', 'string'),
Field('api_id', 'string'),
Field('birthday', 'date'),
Field('created', 'datetime','datetime', default=request.now),
Field('modified', 'datetime','datetime', default=request.now),
format = '%(name)s')
db.define_table('star',
Field('movie_id', db.movie),
Field('star', db.person),
Field('created', 'datetime','datetime', default=request.now),
Field('modified', 'datetime','datetime', default=request.now))
Grid code:
@auth.requires_login()
def manage_movies():
grid = SQLFORM.smartgrid(db.movie)
return locals()
Thanks for taking a look. Apologies if this is a really lame mistake. Trust
that I do RTFM.
On Thursday, August 9, 2012 6:16:58 PM UTC-4, Anthony wrote:
>
> Can you show the model and grid code?
>
> On Thursday, August 9, 2012 4:00:06 PM UTC-4, Mike Girard wrote:
>>
>> Can anyone tell just by looking at this what the problem with the ID and
>> Star fields might be? The record is actually fine. When I click Edit,
>> everything is as it should be.
>>
>> Sorry for not providing the full background on this, for brevity's sake.
>> Was wondering if someone can see the problem just by looking at this.
>>
>>
>> https://lh6.googleusercontent.com/-eS6fJPgPv5k/UCMiWvEM_7I/AAAAAAAAAAc/NzibaZS3H_Y/s1600/Screen+shot+2012-08-08+at+10.35.52+PM.png
>>
>
--