Oleg:
Thanks much for all the info. Although it wasn't what I wanted to hear,
it's better off to know so I don't waste time beating my head against it.
Thanks again.
-Jim
Oleg Broytmann wrote:
On Fri, Aug 03, 2007 at 01:19:10PM -0500, Jim Steil wrote:
The only way in SQLObject to
On Fri, Aug 03, 2007 at 01:19:10PM -0500, Jim Steil wrote:
> > The only way in SQLObject to select columns from multiple tables is
> >sqlbuilder.Select().
>
> I've tried that in the past, but I seem to recall that it doesn't return
> the same type of object as a regular .select(), and that is w
Oleg Broytmann wrote:
On Fri, Aug 03, 2007 at 10:55:06AM -0500, Jim Steil wrote:
Thanks for the response. I do understand all of that, but in the doc
(http://www.sqlobject.org/SQLObject.html#left-join-and-other-joins), it
gives the following example:
MyTable.select(
join=LEFTJOINOn(Non
On Fri, Aug 03, 2007 at 10:55:06AM -0500, Jim Steil wrote:
> Thanks for the response. I do understand all of that, but in the doc
> (http://www.sqlobject.org/SQLObject.html#left-join-and-other-joins), it
> gives the following example:
>
> MyTable.select(
>join=LEFTJOINOn(None, Table1,
>
Thanks for the response. I do understand all of that, but in the doc
(http://www.sqlobject.org/SQLObject.html#left-join-and-other-joins), it
gives the following example:
MyTable.select(
join=LEFTJOINOn(None, Table1,
MyTable.q.name == Table1.q.value))
will return the foll
On Fri, Aug 03, 2007 at 10:15:50AM -0500, Jim Steil wrote:
> x = RailCar.select(...)
>
> The problem is that I don't get any of the fields from the RailStatus
> table in the select.
The problem is not with the join, but with your understanding of
.select(). SQLObject.select() can do simple or
Hi:
I'm having a problem with my left join. I'm joining two tables using:
x = RailCar.select(join=LEFTJOINOn(RailCar, RailStatus,
RailCar.q.id==RailStatus.q.railCarID))
if I then print x, I get:
SELECT RailCar.railCarId, RailCar.carInitials, RailCar.carNumber,
RailCar.active, RailCar.created
