Todd Greenwood wrote:
William -
I know you're trying to be helpful, and I do appreciate your time. But
lines like this drive me crazy:
"""
You can get more details here: http://www.sqlobject.org/SQLObject.html
"""
I reference that page in my original post twice.
*I feel your pain.
If you have not already, have a look at my SQLBuilder LeftJoin saga.
**
http://tinyurl.com/cz946
*
*I got it to "work". But it only returns rows from one table. As near
as I can tell, that is what it is supposed to do.
Over on the SQLObject list, someone asked about that and was told, more
or less, well, of course, since there is no place to put the attributes
from the other table in the object.
Someone asked what the actual utility of SQLJoin was but got no response.
The function of the join methods in sqlbuilder remain a mystery to me.
Note, however, that in the above thread bonono was kind enough to point
me to a way to do real SQL. I have not tried it, since I am trying to
learn to do things the TurboGears way.
But I must confess, I'm feeling more and more that SQLObject is trying
to shoehorn OO into an area where good old SQL is simply far superior.
There are things that are nice about SQLObject, but at times, I find
myself beginning to wonder about the Emperor's state of dress.
-Steve
*
*
*
