sqlobject-discuss

[SQLObject] relation

[<inf...@uc...>]

Hi , first of all sorry for my english, I speak Spanish, but I am working with SQLObject
and I am a newbie, and I dont know how to make a relation among 3 tables M:M
Thanks


--
Participe en Universidad 2010,
del 8 al 12 de febrero del 2010
La Habana, Cuba
http://www.universidad2010.cu
http://www.universidad2010.com

Re: [SQLObject] relation

[Oleg B. <ph...@ph...>]

On Thu, Nov 26, 2009 at 10:19:24PM -0500, inf...@uc... wrote:
> Hi , first of all sorry for my english, I speak Spanish, but I am working with SQLObject
> and I am a newbie,

   Welcome!

> and I dont know how to make a relation among 3 tables M:M

   Probably you need 3 separate relations - table1<->table2,
table2<->table3, table1<->table3.
   What SQL queries do you have in mind? I must say in advance that
high-level API in SQLObject doesn't allow any query to be expressed in
SQLObject's objects, but there is medium-level API that allows you to
execute any SQL query and get back the list of lists of results.

Oleg.
-- 
     Oleg Broytman            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.