Just a guess. Bu.. do you by chance have two applications on the machine with the same name in cfapplication? Maybe a staging site?
I had a staging site and live site on the same machine and I would get weird "phantom data" that would bleed over from the staging site because (I am assuming) that they had the same application name. When I changed the application name the problems went away. G On Thu, May 22, 2008 at 10:24 AM, KDJ The Net Surfer <[EMAIL PROTECTED]> wrote: > Dear guys, thanks in advance for your help! > > My problem is that I've developed this huge application (a kind of > CRM) and it's been working fine for years, but lately it's doing > something odd: sometimes when somebody is going to do something > (like, for example, creating a new date in their calendar), the > application will take the wrong user id (which I suppose it's the > user id of someone else working on the website at the same time). > > I have no idea why it's doing this, but I guess that CF is catching > certain kind of queries. Maybe it's because I'm making every script > to check the database every time it's executed and sometimes it > returns the last query (a catched one) instead of doing the query > with the provided data again? > > The bad thing is that I *can't* reproduce the behaviour. it happens > seemingly randomly every other 3 weeks or month... but sometimes 2 > days in a row.. this is very annoying and of course, insecure, so my > customers are beginning to complain, and of course they won't take > the 'it just happens once every Xk actions'. This should *never* happen. > > I tried to make the queries non-cacheable, but I wonder if there's a > definitive way to make sure that coldfusion is *always* making a > query and *never* catching it and returning the last result? > > Hope I explained myself well. Thank you! > > Oscar.- > __ __ ___ ____ > | \/ / | \ \__ | JC1: "Que pasa, tio?!" \\\\\\ > | < | |> \ || JC2: "El tiempo.." ////////// > |_/\_\ |____/ /| http://www.disneymania.ws > ______________// http://www.amazingdollars.com > /______________/ > http://www.lionking.org/~nyanya<http://www.lionking.org/%7Enyanya> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305885 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
