That error was created becouse in 'cuisines' table field NAME have charset
'NONE' and collate 'NONE'.
>
>
>-
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list
rows = db(
(db.recipes.ID_CUISINE==db.cuisines.id)
).select(db.recipes.ALL)
db._lastsql >>>
('SELECT recipes.ID_CUISINE, recipes.DESCRIPTION, recipes.ID_AUTHOR,
recipes.ID_CATEGORY, recipes.EXPIRATION_DATE, recipes.IMAGE FROM recipes,
cuisines WHERE (recipes.ID_CUISINE =
2 matches
Mail list logo