A portion of this follows:
If I use the representation:
cp_invoice = DBSession.query
(cp_orderheader,cp_orderlines,clients).filter
(cp_orderheader.invoice==invoice).filter
(cp_orderheader.invoice==cp_orderlines.invoice).filter
(cp_orderheader.client_id==clients.client_id).all()
I am able to access the joined tables as:
${cp_invoice[0].cp_orderheader.invoice}
${cp_invoice[0].cp_orderlines.taxable}
${cp_invoice[0].clients.username}
I've not dug through the code/documentation enough to get .join
and .eagerload to work.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears Trunk" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/turbogears-trunk?hl=en
-~----------~----~----~----~------~----~------~--~---
