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
-~----------~----~----~----~------~----~------~--~---
