I fixed it. My column names were screwed up.
Sorry.
On Thursday, August 9, 2012 11:20:31 PM UTC-4, Mike Girard wrote:
>
> 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
>>>
>>
--
