Thanks, my main reasoning for changing the reference is that it would save a query.
I guess I'll just have to add in that query... (to grab the name from the id) On Mon, Jul 23, 2012 at 5:29 AM, Anthony <[email protected]> wrote: > Your reference is wrong -- instead of 'reference db.group_of_events', it > should be 'reference group_of_events.group_name'. But I'm not sure that will > work either -- as mentioned here, keyed tables can only reference other > keyed tables (in your code, you have a standard web2py table referencing a > keyed table). There are other limitations as well. Even if it's redundant, > your tables should all include auto-incrementing id fields. > > Anthony > > > On Sunday, July 22, 2012 3:18:12 PM UTC-4, Alec Taylor wrote: >> >> Looking through my code I realised that I would be better served if I >> could lookup and reference by `group_name` instead of `id`. >> >> I have set `group_name` to: >> Field('group_name', notnull=True, requires=[IS_SLUG(), >> IS_NOT_IN_DB(db, 'group_of_events.group_name')]), >> >> So it is perfect for a public key. >> >> Unfortunately when I set it, I get key errors (to double check, I >> dropped all records and refreshed; still got the error). >> >> Here is a 13 line test-case version: http://pastebin.com/8dLFb8QS >> >> What am I doing wrong; how do I make `group_name` public key? >> >> Thanks for all suggestions, >> >> Alec Taylor > > -- > > > --
