[Reactor for CF] Iterator Join Question

[Brian Kotek]

Here's a question that is stumping us. We're trying to join an iterator to another table. This seems to work, and in the debugging info I can see that the table contained in the iterator is being correctly joined to the target table. However, the problem is that only the columns from the first table are being selected. There doesn't seem to be any way to get Reactor to give me the columns from both tables. Anyone have any ideas?

<cfset local.joinedIterator = local.user.getClient().getClientPermissionIterator().join('ClientPermission', 'ProductModule', 'ProductModule', 'ProductModule').getQuery() />

Results in this query running:

SELECT			
[ClientPermission].[clientID] AS [clientID],  [ClientPermission].[moduleID] AS [moduleID],  [ClientPermission].[productID] AS [productID],  [ClientPermission].[clientPermissionUUID] AS [clientPermissionUUID]

FROM
[GrantsNetwork].[Core].[ClientPermission] AS [ClientPermission] INNER JOIN [GrantsNetwork].[Core].[ProductModule] AS [ProductModule] ON [ClientPermission].[moduleID] = [ProductModule].[moduleID]
WHERE
[ClientPermission].[clientID] = ?


Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 2

As you can see, the join is happening, there just doesn't seem to be any way to get the columns from the ProductModule table. Any ideas appreciated. Thanks.

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --Reactor for ColdFusion Mailing Listreactor@doughughes.netArchives at: http://www.mail-archive.com/reactor%40doughughes.net/-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --