Re: [Reactor for CF] Error loading record

Brian Billings Thu, 06 Jul 2006 12:54:06 -0700

Thank for the quick response.

Im using the version included with the Unity DL (I can't use SVN from here).

At least thats the only problem.

If anyone has a zip they can send that would be great. Otherwise I'll download it when I get to my personal PC.

On 7/6/06, Doug Hughes <[EMAIL PROTECTED]> wrote:

This was fixed in a recent update. When was the last time you got latest?

Doug

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Brian Billings
Sent: Thursday, July 06, 2006 3:39 PM
To: [email protected]
Subject: [Reactor for CF] Error loading record
All,

im getting this message (below) from the SQL server when I attempt to load a record.

I can see by the error that the SQL generated by reactor isnt correct. Notice the WHERE clause is using the alias (UserID) as the column name instead of the actual column name (USER_SK)

Am I doing something wrong in my config file?

<reactor>
<objects>
  <object name="USERS" alias="User">
   <field name="USER_SK" alias="UserID" />
   <field name="USER_NAME" alias="Username" />
   <field name="PASSWORD" alias="Password" />
  </object>
</objects>
</reactor>

Called from C:\CFusionMX7\wwwroot\CERESII\index.cfm: line 33

601 :                          </cfif>
602 :                  </cfsavecontent>
603 :                  <cfoutput>#queryData.query#</cfoutput>
604 :          </cfquery>
605 :

SQL

   SELECT [User].[USER_SK] AS [UserID], [User].[USER_NAME] AS [Username], [User].[PASSWORD] AS [Password] FROM [USERS] AS [User] WHERE [User].[UserID] = (param 1)

DATASOURCE

  CERESII

VENDORERRORCODE

  207

SQLSTATE

  42S22

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



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

Re: [Reactor for CF] Error loading record

Reply via email to