> 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.
Could be... On the other hand if anyone else knows of a url variable (if you use one) to reset / restart the application and that functions by deleting the existing set of variables, then it's possible someone could be passing the reset variable to a page in the url and the error message indicating that the variable is not defined is a result of the ensuing race condition. 1) Person a requests page - variables are loaded, page skips creation of query. 2) Person b requests page and passes the reset variable which deletes the query from the application scope. 3) Person a's page still not finished loading attempts to access the query which no longer exists in the application scope and produces an error. 4) Person b's request recreates the query in the application scope. 5) Person a refreshes page, query exists, request completes ok. Unfortunately even if you haven't given out the url that resets the framework, it's possible that an automated process could cause this problem anyway. A hosting provider I worked with used a webserver log analysis tool which sent an http head request to each page in the webserver's log, including any url variables. Since ColdFusion server is associated with the HEAD verb in the webserver by default, this of course would cause the application to execute the coldfusion page as normal. (I'm guessing the only significant differences are with regard to cgi variables and that once the page is generated none of the content is returned, just any cfheader tags or other http headers which might be attached by the webserver). hth > -----Original Message----- > From: Dan G. Switzer, II [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 30, 2005 5:36 PM > To: CF-Talk > Subject: RE: weird coldfuson errors > Russ, >>We've been getting weird errors in our sites. I just can't >>explain it.. If >>this was a previous version of coldfusion I would've >>guessed some problem >>with locking, but from what I've read, you don't need to >>lock anymore as >>much in MX. > This error might be caused if the query is returning zero > records. Is one of > the arguments you're passing in to the CFC random on page > reload? If so that > could be affecting the total rows being returned between > page reloads, thus > causing the error. No zero records in a query won't produce the "[x] not found in [y]" error... A missing column in a query however typically doesn't produce that error either -- it normally produces an ugly "[confusing description of query] is not indexable by [column]" error. So I would guess, because I've seen cases where the "[x] not found in [y]" error isn't entirely accurate, that it's actually not finding [x] (the query) rather than not finding [y] (the column) in [x]. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:211012 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
