I have a bunch of tables, for simplicity lets say: db.define_table('foo', Field('foo_id'), # str Field('bar', 'reference haz.haz_id'), primarykey=['foo_id'] )
db.define_table('haz', Field('haz_id'), # str Field('foo_id', 'reference foo.foo_id'), primarykey=['haz_id'] ) (and yes, bad DB design; but it's to prove a point!) It gives me an error; on my actual db it shows: <type 'exceptions.TypeError'> argument of type 'bool' is not iterable On this test-case it gives: TypeError: %d format: a number is required, not NoneType How am I supposed to reference string keys between tables? E.g.: is there an `IS_IN_DB` syntax I should be using? Thanks for all suggestions, Alec Taylor PS: The keys on my actual dataset are MD5 hashes -- --- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.