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
>>
>

-- 



Reply via email to