When trying the example in the new slide show:
...db = SQLDB('sqlite://storage.sqlite')
db.define_table('dog',
SQLField('name'),
SQLField('father_id','reference dog'),
SQLField('mother_id','reference dog'))
..
data:
5 selected
dog.id dog.name dog.father_id dog.mother_id
1 biff None None
2 bella None 1
3 fred None 2
4 harry 2 1
5 rover 3 2
def index():
father=db.dog.with_alias('father')
mother=db.dog.with_alias('mother')
rows = db().select(db.dog.name, db.father.name, db.mother.name,
left=(db.father.on(db.father.id==db.dog.father_id),
db.mother.on
(db.mother.id==db.dog.mother_id)))
return dict(rows=rows)
I get the error:
... self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
OperationalError: no such table: LEFT
Any ideas? thanks.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
