What is the SQL generated on this?
You may need to specify which join you want to use as it is quite likely
auotjoining both to each other.
Mark
On Tue, Aug 18, 2009 at 10:00 AM, Matthew matthewbchamb...@gmail.comwrote:
*** CFM option 2 ***
query = getTransfer().createQuery(FROM Tree AS
Turn on debug output in your CFAdmin. It will show all queries that were
run.
--~--~-~--~~~---~--~~
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
The SQL show up in ColdFusion debugging.
Mark
On Tue, Aug 18, 2009 at 10:12 AM, Matthew matthewbchamb...@gmail.comwrote:
Hi Mark
I'm not sure how to obtain the SQL because option 1 returns an empty
object and option 2 returns this Message: The property that was
searched for could not be
Further to my last response;
If I add my own join statement ON child.parentContentTreeId =
parent.contentTreeId it throws this error The property
'parentTreeId' could not be found in the object 'Tree
Cheers
Matthew
On Aug 18, 10:41 am, Matthew matthewbchamb...@gmail.com wrote:
Hi Mark
You
Matthew, please see:
http://docs.transfer-orm.com/wiki/Transfer_Query_Language.cfm#Specific_Join
Mark
On Tue, Aug 18, 2009 at 10:45 AM, Matthew matthewbchamb...@gmail.comwrote:
Further to my last response;
If I add my own join statement ON child.parentContentTreeId =
parent.contentTreeId
You bloody ripper. Worked a treat!!! Thanks a million Mark. So this is
how you get around the you can't have XXX as both a property and a
relationship.
On Aug 18, 10:49 am, Mark Mandel mark.man...@gmail.com wrote:
Matthew, please