Thanks Mark, should have read your response more closely. That worked perfectly. Thanks again. Sean
On Apr 30, 5:49 pm, Mark Mandel <[email protected]> wrote: > Sean, > > I said use a Specific join, not a manual > join.http://docs.transfer-orm.com/wiki/Transfer_Query_Language.cfm#Specifi... > > select child.id from category as Child > left outer join > category as Parent > on Parent.childCategory > where Parent.id is null > > I * think * would be the correct TQL. > > Mark > > > > On Thu, Apr 30, 2009 at 11:18 PM, Sean Coyne <[email protected]> wrote: > > > I added it as a property and added the manual join and it works as > > expected now, but that still seems odd to me to have to specify the > > foreign key as a property and specify the relationship as well. Oh > > well whatever works I guess. > > > Sean > > > On Apr 30, 9:08 am, Sean Coyne <[email protected]> wrote: > > > Mark, > > > > I can't specify a manual join on parentid_fk because parentid_fk is > > > not a property specified in the transfer sql. I get a "The property > > > 'parentid_fk' could not be found in the object 'category'" error when > > > I try that. > > > > Sean > > -- > 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 -~----------~----~----~----~------~----~------~--~---
