I Have a TurboGears-model:
class Usuario(SQLObject):
ruta = UnicodeCol(alternateID = True, length=10, notNone=True)
nombre = UnicodeCol( length=50, default = '')
lecturas = MultipleJoin("Lectura")
class Lectura(SQLObject):
periodo=UnicodeCol( length=6, notNone=True)
consumo=IntCol(default=0)
usuario = ForeignKey("Usuario", notNone=True)
My specific problem is:
"SELECT Lectura.periodo, Lectura.consumo, Usuario.ruta, Usuario.nombre
FROM Lectura INNER JOIN Usuario ON Lectura.usuario_id=Usuario.usuario_id
WHERE Lectura.periodo='200601' ORDER BY Usuario.ruta"
Now, how do you express that in SQLObject?
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
