*Re: Firebird* I just tested this version of web2py and I noticed a problem. See the new authapi.py, line 452:
rows = self.db(self.table_group().role == role).select() The* new code* produces this SQL: SELECT "auth_group"."id", "auth_group"."role", "auth_group"."description" FROM "auth_group" WHERE ("auth_group"."role" = 'admin') The *old code* in tools.py produced this: SELECT auth_group.id, auth_group.role, auth_group.description FROM auth_group WHERE (auth_group.role = 'admin') *So what's the problem?* Firebird, by default, creates all entity names in uppercase. This is not usually a problem because the SQL is interpreted as case-insensitive. However, when the names are quoted, they become case-sensitive and therefore the new code doesn't work. *The solution for Firebird?* Either, uppercase the entity names before they are quoted, or dispense with the quotes (as in the old code). -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.