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