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).
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
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
