Sean, I said use a Specific join, not a manual join. http://docs.transfer-orm.com/wiki/Transfer_Query_Language.cfm#Specific_Join
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 -~----------~----~----~----~------~----~------~--~---
