Re: [SQLObject] more powerful joins on the fly...

On Sat, 2003-03-01 at 16:57, Oisin Mulvihill wrote:
> Hi,
> 
> I've really only started using MySQL in the past month. From the 
> beginning
> I've tried to use it through an ORM and SQLObject has proved to be the
> one I've had the most success with to date. I've successfully used it 
> in one
> project already and now I'm hoping to use it in another project.

Well, hey, except for me no one's used it very long...

> My new project however needs to be be able to do more powerful joins. I 
> would
> like to be able to create a single table by joining information from 
> other tables I have
> at 'run time'. I don't mean creating a class with a _join[] member, I 
> mean creating
> a join from a query. I am wondering if its possible to do this or how I 
> might be able
> to go about implementing this in SQLObject?

I'm not sure -- I haven't figured out how other kinds of joins would
really work in SQLObject.  Maybe you could give the schema and it will
be more clear from that...

  Ian