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

Reply via email to