I am trying the left outer join to see if it returns what I need. However, I am getting an error.
Here is the line of code where the optionality is set: <cf_JoinToParent table="PlumUser" primaryKeyColumn="UserId" optionality="optional" foreignKeyColumn="CompletedBy" > Here is the error message: An invalid optionality was passed to JoinToParent. Valid values are "Mandatory" or "Optional". The error occurred in C:\CFusionMX7\wwwroot\marylandPro\customtags\JoinToParent.cfm: line 24 22 : message="An invalid optionality was passed to JoinToParent." 23 : errorCode="61090" 24 : detail="Valid values are ""Mandatory"" or ""Optional""."> 25 : </cfif> 26 : What am I doing wrong? Thanks, Mark -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Adam Churvis Sent: Thursday, September 29, 2005 9:56 AM To: [email protected] Subject: Re: [plum] right join If the Plum custom tag that needs data is working over tables that have an optional relationship between them, the tag will formulate a left outer join to pass to DatabaseBlocks.cfc's fromClause argument of the SelectRecords method. If the Plum custom tag that needs data is working over tables that have a mandatory relationship between them, the tag will formulate an inner join to pass to DatabaseBlocks.cfc's fromClause argument of the SelectRecords method. If you want to select from a right outer join, you can formulate a custom query. Respectfully, Adam Phillip Churvis Member of Team Macromedia Certified Advanced ColdFusion MX 7 Developer http://www.ProductivityEnhancement.com Download Plum and other cool development tools, and get advanced intensive Master-level training: * C# & ASP.NET for ColdFusion Developers * ColdFusion MX Master Class * Advanced Development with CFMX and SQL Server 2000 ----- Original Message ----- From: "Mark Fuqua" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, September 29, 2005 9:48 AM Subject: [plum] right join > It seems database blocks creates left joins. Is there an easy way to have > it use a right join for certain queries? I guess the easiest way would be > to just use a custom query. > > Also a related question: Is there a way to keep cf from caching a specific > query? > > Mark > > > > ********************************************************************** > You can subscribe to and unsubscribe from lists, and you can change > your subscriptions between normal and digest modes here: > > http://www.productivityenhancement.com/support/DiscussionListsForm.cfm > ********************************************************************** > ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm ********************************************************************** ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
