Thanks Dan, This makes sense. So it's basically a race condition. Since we're using the same variable name for the query throughout the cfc, which is cached, if more then 1 request runs a method in the cfc at the same time, then the last one that completes will overwrite the variable. And when you display the query, only one of the queries would be available for both pages. And if they ran different methods, then one of them would not get the query it expected and crash.
So to fix this do I have to do something like this: <cfset var thisQry=""> <cfquery name="thisQry" datasource"somedsn"> Select somestuff from somewhere </cfquery> <cfreturn thisQry> Is there a way to avoid the cfset and put it directly in the cfquery? Such as something like this: <cfquery name="var thisQry"> Russ -----Original Message----- From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] Sent: Friday, July 01, 2005 10:00 AM To: CF-Talk Subject: RE: weird coldfuson errors Russ, >Nothing is being passed in random... The query should always return a >record... I am using the same exact url on reload. I'm thinking maybe it's >a memory issue. I'm going to have crystaltech replace the memory and see >if >it helps. Are you correctly declaring the query name? If you're not declaring the query name in your component, you could very well be running into a sharing violation. You should be using the "var" keyword to declare all local variables in a function. -Dan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211021 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
