Very odd Error... Need Help... related to a coldfusion cluster...

So, hopefully someone out there can help me, I have a very strange error that I can not track down...

Where I work, we have a development environment with a single Cold Fusion server (for this project they are still using Cold Fusion 5 and upgrading is not a possible solution). The code that I wrote works fine on here. We have a second environment, a test environment with a single Coldfusion 5 server. My code works in here fine… Now comes the problem, in the production environment, we have a load balanced cluster of three Coldfusion 5 servers.

The code does this:
-Use a query to retrieve a value from a database
-Set a variable called “code” to a specific string from the query
-Insert record in the database using query results
-Call another page with CFInclude

Until this point, everything is correct on all servers but the value of “CODE’ is no longer accurate, but only when the page is loaded on the cluster… the value of CODE is set using <cfset code = query…> and the value is used in another query on the included page, but the value comes out at 1 when it should be a 25 character string.

Any ideas???

-Matt

No idea...I can't see any reason why it being on a cluster would matter. Are these sets of queries inside a single cftransaction block?

Because none of the queries really depend on each other, they are not inside a cftransaction block... I usually do my error handling by checking for number of records returned and so on. The query that is having problems is just a SELECT statement with it's value coming from another SELECT statement, who's output is used successfully in an insert statement right above the CFINCLUDE statement.

If it would help, here is the code...
file 1:

The bold sections are where I just took out some various parts that are not needed... The italics section is where the varible in question get set... Also, the CFINCLUDE does work correctly with the full path, we added the mappings, but the same problem was orccuring when we were using relative paths...

File 2:

Again, I cut out most of the query, but it is a standard select statement, and it works when not working from our production cluster. There is nothing above the query that checks or does anything with the CODE variable. In the code that works, CODE is equal to a 25 character string while in the cluster enviorment the value is 1

I hope someone can help me out... Thanks...
-Matt

Never mind... I have solved the problem, somehow when I recreated my database the last time in production one of my VARCHAR fields got converted to a NVARCHAR field, which Coldfusion does not like. This seemed to only have happened in my production database, thus the reason that my other enviornments were not affected...

Oh well....
Live and learn...

-Matt