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