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. > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
