Yes... I believe so. On Monday, October 2, 2017 at 7:53:13 PM UTC-4, Anthony wrote: > > Was that field originally a regular reference field and then you changed > it to a list:reference field? > > On Monday, October 2, 2017 at 3:45:38 PM UTC-4, LoveWeb2py wrote: >> >> Anyone have feedback? I have been banging my head against this all day... >> >> On Sunday, October 1, 2017 at 4:52:39 PM UTC-4, LoveWeb2py wrote: >>> >>> Hello, I'm trying to create a simple interface that allows users to >>> select multiple files and create a name for the bundle. I've followed the >>> example in the book but keep getting the same error... FOREIGN KEY >>> constraint failed. >>> >>> When I look in all_files, it has the keys available. >>> >>> I tried following this example: >>> http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#listtype-and-contains >>> >>> I am wondering if it has something to do with the filetype being an >>> upload field. >>> >>> I've even tried getting the reference object id by doing >>> >>> s = db(db.all_files.id>0).select() >>> file_ids = [x.id for x in s if int(x) in all_files] >>> >>> name = 'test_group_name' >>> file_ids = [1L, 2L, 3L] >>> >>> db.file_groups.insert(group_name=test_id, filename=file_ids) >>> >>> >>> >>> Function argument list >>> >>> (self=<pydal.adapters.sqlite.SQLite object>, table=<Table file_groups >>> (id, group_name, filename)>, fields=[(<pydal.objects.Field object>, [27, >>> 28, 29, 33, 34, 31, 30, 32, 35, 36]), (<pydal.objects.Field object>, >>> 'filegroup1')]) >>> >>> >>> >>> >>> >>> db.define_table('all_files', >>> Field('filename','upload', unique=True), >>> Field('uploaded_by', db.auth_user), >>> format="%(filename)s") >>> >>> db.define_table('file_groups', >>> Field('group_name'), >>> Field('filename', 'list:reference all_files')) >>> >>> >>> >>> Sincerely appreciate any help... >>> >>
-- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
