Actually, I got it to work. It took a server restart, but that seemed to clear it up. I guess CF had cached something, although I never had to restart after previous upgrades. I guess this is one of the "best practices" when upgrading.

Thanks for your help,
Brad

On Dec 1, 2006, at 3:34 PM, [EMAIL PROTECTED] wrote:

Try going "back" a few revisions (if you have a Subversion client) and see what happens (cf. my experiences in another thread of today)....

W.

On Nov 30, 2006, at 00:19, Brad Haas wrote:

The database structure is not of my design (I inherited it). Basically, UserSecurity is a table to store user data. From what I gather, a long time ago the table was actually name "Users", but that is a reserved word so it was changed. That is why UserID is the primary key from the UserSecurity table. The Distributors table is a list of distributors. The DistributorUser table is an index table that joins together users with the distributors.

I know...it is pretty screwed up, but it was working fine until I updated Reactor. Also, the config file may be a little obfuscated because I messed around with it trying to get rid of the error, but nothing helped.

Thanks,
Brad

On Nov 29, 2006, at 6:08 PM, [EMAIL PROTECTED] wrote:

Let me try to understand what you're modeling:
* A DistributorUser belongs to a Distributor
* A Distributor is assigned a UserSecurity, or a UserSecurity belongs to a Distributor (you wanna go both ways in your iterators)

I'm puzzled: if the above is true, then why the link from DistributorUser to UserSecurity with a field called UserID? And why are the link names equal to the name of the DistributorUser table? I'm missing something here... ;-)


On Nov 29, 2006, at 23:47, Brad Haas wrote:

I appreciate your help.

System:
Reactor: latest build
CFMX 7
Server: Windows 2003
DB: SQL 2000

Here is the relevant part of my config file:


        <objects>
                <object name="UserSecurity">
                        <hasOne name="Distributors">
                                <link name="DistributorUser" />
                        </hasOne>
                </object>
                
                <object name="DistributorUser">
                        <hasOne name="UserSecurity">
                                <relate from="UserID" to="UserID" />
                        </hasOne>
                        <hasOne name="Distributors">
                                <relate from="DistributorID" to="DistributorID" 
/>
                        </hasOne>
                </object>
                
                <object name="Distributors">
                        <hasOne name="UserSecurity">
                                <link name="DistributorUser" />
                        </hasOne>
                </object>
        </objects>
                
Thanks as always,
Brad


On Nov 29, 2006, at 5:22 PM, [EMAIL PROTECTED] wrote:

More info required for getting at the root cause: DB ? Your Reactor config?

W.

On Nov 29, 2006, at 23:15, Brad Haas wrote:

Yep. That's what I thought. I've blown away the files and flushed the application scope and it happens over and over again. I have no clue why this is happening.

Thanks,
Brad

On Nov 29, 2006, at 5:03 PM, [EMAIL PROTECTED] wrote:

Brad, the condition of the CFIF seems to be missing... Try re- generating the files...

W.

On Nov 29, 2006, at 22:37, Brad Haas wrote:

After upgrading to the latest build I blew away all the App data and project files to get a fresh start. Parts of the application is working correctly, but I ran into a strange error on a page that had been working previously.


The error message is:

 Invalid CFML construct found on line 206 at column 25.
ColdFusion was looking at the following text:

>

The CFML compiler was processing:

    * a cfif tag beginning on line 204, column 18.
    * a cfif tag beginning on line 204, column 18.

For some reason it looks like Reactor is adding extra space and line breaks to a <cfif> statement for the code generated for a record object. Here's the code generated by Reactor that is causing the problem:


<cffunction name="getUserSecurity" access="public" output="false" returntype="any" _returntype="reactor.project.Autec.Record.UserSecurityRecord">
                <cfset var UserSecurity = 0 />
                
<!--- load the initial UserSecurity record. this will be empty ---> <cfif NOT StructKeyExists(variables.children, "UserSecurity") OR (
                                StructKeyExists(variables.children, 
"UserSecurity")
                                AND NOT 
IsObject(variables.children.UserSecurity)
                ) >
<cfset UserSecurity = _getReactorFactory().createRecord ("UserSecurity") />
                        <cfset UserSecurity._setParent(this, "UserSecurity") />
                        <cfset variables.children.UserSecurity = UserSecurity />
                </cfif>
                
<!--- if this object has an related values that are not the same as the values in this object then load the correct values --->
                <cfif
                        
                        >
                        
                        <cfset variables.children.UserSecurity.load('') />
                </cfif>
                
                <cfreturn variables.children.UserSecurity />
        </cffunction>


Anyone have any ideas why this is happening?

Thanks,
Brad



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


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


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

Reply via email to