I do want to select images because Images are added to articles later on. I
want to show a list of the newest pictures but I don't want to show 6
images for the same article(the list I show will contain 6 images)
On Thursday, January 24, 2013 8:41:42 PM UTC+1, Derek wrote:
>
> Well, you don't want to select images then, you want to select articles -
> then get a single image attached to the article.
>
> On Thursday, January 24, 2013 8:51:42 AM UTC-7, BlueShadow wrote:
>>
>> Hi I got two tables in my application one for images and one for
>> articles. an artical can have multiple images attached to it.
>> What I want to do is displaying a list of the newest images but there
>> should only be one per article
>> db.define_table('Images',
>> Field('Headline',length=1024),
>> Field('Image','upload'),
>> Field('Submitted','datetime',default=datetime.datetime.now(),writable
>> =False,readable=False),
>> format = '%(Headline)s'
>> )
>>
>> db.define_table('Article',
>> Field('Title',length=512),
>> Field('Content','text'),
>> Field('Submitted','datetime',default=datetime.datetime.now()),
>> Field('TopImage','reference Images', requires=IS_EMPTY_OR(IS_IN_DB(db
>> , db.Images.id), null=None)),
>> Field('BottomlImage','reference Images', requires=IS_EMPTY_OR(
>> IS_IN_DB(db, db.Images.id), null=None)),
>> Field('BottomrImage','reference Images', requires=IS_EMPTY_OR(
>> IS_IN_DB(db, db.Images.id), null=None)),
>> Field('InTextImage','list:reference Images')
>> )
>>
>> Right now I got no clue how I should start to solve the problem.
>> I want to do this because one article could have like 10 pictures and
>> would completly fill the list of new images.
>>
>
--
