RE: [Reactor for CF] bug?

Theuns Pretorius Sun, 10 Sep 2006 23:12:17 -0700

Thanks Beth !

Sorry, I never logged it :-) I've been fortunate till then. Every time I ran into a bug someone else had fixed it already!

Should I run into another bug, I'll definitely log it! (We use trac with svn as well so I know the drill)

For now, we're struggling with some cold spring bugs - non reactor related - arrrggghhhh

Regards,

Theuns(South Africa)

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Beth Bowden
Sent: 09 September 2006 06:49 PM
To: [email protected]
Subject: Re: [Reactor for CF] bug?

Theuns,

I logged this into the bug tracker (see http://trac.reactorframework.com/reactor/ticket/72) and fixed it. As Doug said, logging it into the bug tracker is the best way to go. If you run into more, log them on the bug tracker. The url is http://trac.reactorframework.com/reactor. Click on "Add ticket".

Beth

On 9/1/06, Doug Hughes <[EMAIL PROTECTED]> wrote:

Has it been logged into the bug tracker? If so, it's an easy fix.

Doug

From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Theuns Pretorius
Sent: Friday, September 01, 2006 3:34 AM
To: [email protected]
Subject: RE: [Reactor for CF] bug?

Has this bug been fixed yet?

I found this small mistake in reactor in the DAOs:

</cfif>

As you can see, the Error message is the same for no result and for more than one result on the read method of the DAO.

NOTE: that the exception type is different though.

From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Doug Hughes
Sent: 01 September 2006 05:33 AM
To: [email protected]
Subject: RE: [Reactor for CF] Iterator Join Question

An iterator is an iterator for one specific object type. It doesn't create another object type on the fly. If you need a record as a result of your join try making either a view of the data and turning that into a record or using a method on a gateway.

HTH,

Doug

From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED]] On Behalf Of Brian Kotek
Sent: Thursday, August 31, 2006 10:24 PM
To: [email protected]
Subject: [Reactor for CF] Iterator Join Question

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.

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.11.7/432 - Release Date: 2006/08/29

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.11.7/432 - Release Date: 2006/08/29

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

--
Internal Virus Database is out-of-date.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.11.7/432 - Release Date: 2006/08/29

RE: [Reactor for CF] bug?

Reply via email to