A shot in the dark but, could "tmp" be a reserved word or some such? Did you try changing the name of the query? Just a guess.
G! On Tue, Oct 26, 2010 at 1:21 PM, Matt Quackenbush <[email protected]>wrote: > > Okay, I cannot for the life of me figure this one out. This is essentially > a basic CF insert... > > <cfquery name="tmp"> > insert into foo (field,list) > select > <cfqueryparam value="#bar#" />, > othertable.field > from > othertable > where > othertable.otherfield = <cfqueryparam value="#blabla#" /> > ; > select scope_identity() as newID from foo; > </cfquery> > <cfdump var="#tmp#" /> > > And the result is a big fat "TMP is undefined" exception being thrown. > > This code is being run on CF 8.0.1 against SQL Server 2003. The exact same > code works flawlessly on CF9.0.1 against SQL Server 2008. > > Any ideas? > > Thanks in advance. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338569 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
