Cheers, both of these worked.
On Mar 31, 5:19 pm, Michael Bayer mike...@zzzcomputing.com wrote:
oh, you could send that as a tuple to join, i.e.
db.devmap_device.join((db.devmap_manufacturer,
db.devmap_device.manufacturer_id == db.devmap_manufacturer.id)).first()
this because join()
You can't just throw filter expressions into the join call in modern sqla. Try
db.devmap_device.join(db.devmap_manufacturer).filter(db.devmap_device.manufacturer_id
== db.devmap_manufacturer.id).first()
-Jonathan
On Tue, Mar 31, 2009 at 8:23 AM, Stu.Axon stu.a...@gmail.com wrote:
Heres some
oh, you could send that as a tuple to join, i.e.
db.devmap_device.join((db.devmap_manufacturer,
db.devmap_device.manufacturer_id == db.devmap_manufacturer.id)).first()
this because join() accepts a list of join conditions, a composite
condition is sent as a tuple.
On Mar 31, 2009, at