There major problem with upgrading to CFMX6.1 is the fact that the same application tends to hang after a few hours of use.
This sounds like a database driver issue. There are tech notes on the website about this I think. Check:
http://www.macromedia.com/support/coldfusion/
Hmmm I think I figured out the problem with this (and its not 6.0 specific anymore as I managed to replicate on the 6.1 servers).� I assume that the Result Set object is in a shared memory scope with its reference pointer returned to the user.� However if another user hits the same function before the initial user has finished, the initial reference pointer get over written and becomes redundant as it is replaced by the new pointer causing the initial user to have a read error, as the object it is referencing is not visible any more.
This sounds extremely unlikely - the query object is created on the fly in each request so different users cannot collide (this issue came up on another mailing list recently and I confirmed with the product team that your supposition is not the case). It must be some other issue in your code. I strongly suspect you are not using 'var' to declare the query object! You do this:
<cffunction ...>
<cfset var resultObject = 0/>
<cfquery name="resultObject" ...
...
</cfquery>
</cffunction>That 'var' declaration is very important. Without it, your query is stored as an *instance* variable of the component. If your component is in shared scope, each call to the function will use the same variable, hence the behavior you're seeing.
Until we upgrade to 6.1 would creating a dynamic variable to hold this information using time stamps temporarily fix such an error. Eg:
I'd have to see some of your code to know what's wrong and what would fix it...
Sean A Corfield -- http://www.corfield.org/blog/
"If you're not annoying somebody, you're not really alive." -- Margaret Atwood
--- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
