also please don't double post, simple things like this could be answer in
the TG mailing list.
the unspoken rule is if your running SO on top of TG email there if noone
knows forward it here. and of course search the archives/google before
asking :)
On 1/26/07, Raju Subban <[EMAIL PROTECTED]> wrote:
Hi,
I am looking to get the data from muliple tables.
Currently I am get Qualifier.select() and for each value init I get
Process.id(),BondWire.id().
If i my SQL I can do it in call. (shown below). How can I accomplish the
same ??
------------------------------------------
mysql> select process.process , qualifier.id,bond_wire.type from
process,bond_wire, qualifier where process.id=qualifier.process_id and
bond_wire.id=qualifier.bondwire_id;
+---------+----+--------+
| process | id | type |
+---------+----+--------+
| VIP11 | 1 | Copper |
| ABCD5 | 2 | Copper |
+---------+----+--------+
2 rows in set (0.00 sec)
I want to be able to do. How can I perform this?
My model simplified looks like this
----------------------------------------------------------
class Process(SQLObject):
process = StringCol(length=50, alternateID=True)
class BondWire(SQLObject):
type = StringCol(length=50, alternateID=True)
class Qualifier(SQLObject):
qual = StringCol(length=3, notNull=True)
process = ForeignKey('Process')
bondwire = ForeignKey('BondWire')
-------------------------------------------
Thank you
Raju
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" 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?hl=en
-~----------~----~----~----~------~----~------~--~---
-------------------------------------------------------------------------
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
