I would like to create a many-to-many relationship in the following
model, where many "stories" can appear in many different
"roadtrips" (think songs to mixtapes).

db.define_table(
    'roadtrip',
    Field('name'),
    Field('description', 'text'),
    Field('created_by',default=me,writable=False,readable=False),
 
Field('created_on','datetime',default=request.now,writable=False,readable=False)
    )

db.define_table(
    'story',
    Field('user_id', db.users,readable=False,writable=False),
    Field('roadtrip_id', db.roadtrip),
    Field('story_id', 'integer'),
    Field('title'),
    Field('latitude'),
    Field('longitude'),
    Field('comment', 'text'),
    Field('created_by',default=me,writable=False,readable=False),
 
Field('created_on','datetime',default=request.now,writable=False,readable=False)
    )

db.story.roadtrip_id.requires=IS_IN_DB(db(db.roadtrip.created_by==me),'roadtrip.id','%
(name)s')

I am able to create a multiple-select element on the CRUD form by
simply adding "multiple=True" to this

db.story.roadtrip_id.requires=IS_IN_DB(db(db.roadtrip.created_by==me),'roadtrip.id','%
(name)s', multiple=True)

However, I am receiving the error:

TypeError: int() argument must be a string or a number, not 'list'

I posted the traceback here: http://pastie.textmate.org/1187996

(as an aside, is there a better way to post a traceback that is more
readable, should I just copy/paste from the html error page, as
opposed to the logged file under errors?)

Reply via email to