This is awesome! Thanks for the example!
On Thursday, August 30, 2012 1:56:09 PM UTC-7, Anthony wrote:
>
>
>
> db.define_table('person', Field('name'), Field('email'))
> db.define_table('dog', Field('name'), Field('owner', 'reference person'))
> db.executesql([SQL code returning person.name and dog.name fields], fields
> =[db.person.name, db.dog.name])
> db.executesql([SQL code returning all fields from db.person], fields=db.
> person)
> db.executesql([SQL code returning all fields from both tables], fields=[db
> .person, db.dog])
> db.executesql([SQL code returning person.name and all db.dog fields],fields
> =[db.person.name, db.dog])
>
>
--
