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