On Apr 20, 2007, at 9:46 AM, Oleg Broytmann wrote:
> Hello!
>
> On Thu, Apr 19, 2007 at 03:22:59PM -0400, Fred C wrote:
>> Sorry but that doesn't work. I get that error OperationalError: near
>> "tag": syntax error.
>> The generated request is
>>
>> 1/QueryR : SELECT item.id, item.itemhash, item.link, item.title,
>> item.summary, item.updated, item.relations_updated, item.rate,
>> item.category FROM item LEFT JOIN item_tag ON ((item.id) =
>> (item_tag.item_id)) tag LEFT JOIN item_tag ON ((tag.id) =
>> (item_tag.tag_id)) WHERE ((tag.term) = ('apple')) ORDER BY updated
>> DESC
>
> Aha, good catch. A bug in SQLObject - it has forgotten to add a
> comma
> between JOINs. I just fixed the bug and committed the fix in the
> revisions
> 2568-2572 (0.7, 0.8, 0.9 branches, trunk and docs); the fix will be
> included in the next round of releases (due in the next few days).
Cool, I'll wait for the next release then.
Thanks.
>
> Oleg.
> --
> Oleg Broytmann http://phd.pp.ru/
> [EMAIL PROTECTED]
> Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
