RE: [Reactor for CF] Error loading record

[Doug Hughes]

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