[Reactor for CF] Error loading record

[Brian Billings]

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
reactor@doughughes.net
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --