Thanks, reported. I also blogged about it at http://www.ruslansivak.com/index.cfm/2006/8/17/ColdFusion-Var-Bug
> -----Original Message----- > From: Robertson-Ravo, Neil (RX) [mailto:Neil.Robertson- > [EMAIL PROTECTED] > Sent: Thursday, August 17, 2006 9:13 AM > To: CF-Talk > Subject: RE: ColdFusion var bug? > > Go/wish > > > > > -----Original Message----- > From: Russ [mailto:[EMAIL PROTECTED] > Sent: 17 August 2006 13:36 > To: CF-Talk > Subject: RE: ColdFusion var bug? > > So how would I go about submitting this to macrodobe? > > > -----Original Message----- > > From: Ben Nadel [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, August 16, 2006 5:48 PM > > To: CF-Talk > > Subject: RE: ColdFusion var bug? > > > > Russ, > > > > That looks like a bug to me. > > > > ....................... > > Ben Nadel > > www.bennadel.com > > > > -----Original Message----- > > From: Russ [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, August 16, 2006 5:33 PM > > To: CF-Talk > > Subject: ColdFusion var bug? > > > > Looks like I found a bug in coldfusion in regards to varing variables in > a > > cfc. Here is the example code to reproduce. > > > > > > > > <cffunction name="method1"> > > > > <cfset var myQryTest=""> > > > > > > > > <cfquery name="myQryTest" > > datasource="#application.mydsn#"> > > > > DELETE FROM table > > > > WHERE tableid=-1 > > > > </cfquery> > > > > > > > > <cfquery name="myQryTest" > > datasource="#application.mydsn#"> > > > > select tableid from users where tableid=1 > > > > </cfquery> > > > > </cffunction> > > > > <cffunction name="method2"> > > > > <cfdump var="#myQryTest#"> > > > > </cffunction> > > > > > > > > > > > > Then run this on a test page. > > > > <cfobject name="application.mycomponent" component="mycomponent"> > > > > <cfinvoke component="#application.mycomponent #" method="method1"> > > > > <cfinvoke component="#application mycomponent #" method="method2"> > > > > > > > > If you've set everything up right, you'll see a dump of a query. In > > reality > > you should be getting an exception. > > > > > > > > > > > > I think what happens is when the first query runs, it deletes the > > variable, > > since it doesn't return anything. When the second select query runs, it > > recreates the variable as a regular variable which is local to the cfc, > > not > > the function. > > > > > > > > Is this a CF bug? I got around it by creating a local struct and then > > putting those variables into that struct, but in general, this is not > > intended behaviour, correct? > > > > > > > > > > > > > > > > Russ > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250152 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
