Joseph, Let us know if the manual join works, I can see where you could run into issue combining an outer join with a where clause.
Mark On Tue, Mar 31, 2009 at 5:27 AM, Brian Kotek <[email protected]> wrote: > It sounds like you want a manual join: > http://docs.transfer-orm.com/wiki/Transfer_Query_Language.cfm#Manual_Joins > > > On Mon, Mar 30, 2009 at 1:45 PM, jarofclay <[email protected]>wrote: > >> >> More clarification. We were looking for a way to mix a specific join >> and a manual join. The potential work-a-around we have now is to make >> two joins. >> >> On Mar 30, 11:25 am, jarofclay <[email protected]> wrote: >> > As a clarification, Transfer 1.1 on MSSQL >> > >> > An example, given: >> > >> > <package name="post"> >> > <object name="Post" table="tbl_Post"> >> > <id name="IDPost" type="numeric"/> >> > <property name="Title" type="string" >> column="post_Title"/> >> > <property name="Body" type="string" column="post_Body"/> >> > <property name="DateTime" type="date" >> column="post_DateTime"/> >> > >> > <manytomany name="Category" table="lnk_PostCategory"> >> > <link to="post.Post" column="lnkIDPost"/> >> > <link to="system.Category" >> column="lnkIDCategory"/> >> > <collection type="array"> >> > <order property="OrderIndex" >> order="asc"/> >> > </collection> >> > </manytomany> >> > </object> >> > </package> >> > >> > <package name="system"> >> > <object name="Category" table="tbl_Category"> >> > <id name="IDCategory" type="numeric"/> >> > <property name="Name" type="string" >> column="category_Name"/> >> > <property name="OrderIndex" type="numeric" >> > column="category_OrderIndex"/> >> > </object> >> > </package> >> > >> > TQL Query >> > >> > "from post.Post as Posts left outer join system.Category as >> > Categories" >> > >> > This query works (but what is the join?), but when we want to add >> > another criteria to the join we have problems. So if we only wanted >> > categories with a name starting with "Red" >> > >> > "from post.Post as Posts left outer join system.Category as Categories >> > on Categories.Name like 'Red%' and ??????" >> > >> > We are wondering what the ?????? would be. >> > >> > On Mar 30, 11:16 am, Joseph Swenson <[email protected]> wrote: >> > >> > >> > >> > > How do I specify the join of a manytomany relationship in TQL? >> > >> > > For example, I have a TQL statement which is joining correctly but I >> > > want to add another item to "ON" but I'm not clear on how the join is >> > > happening currently. >> >> > > > > -- E: [email protected] W: www.compoundtheory.com --~--~---------~--~----~------------~-------~--~----~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---
