1) send the real code to avoid all the "gee that's missing" crap ;-)
2) I have never seen CFQUERYPARAM used in the SELECT clause before...only ever the WHERE clause So to me that is odd....doesn't mean it's not OK Cheers On Tue, 2010-10-26 at 12:21 -0500, Matt Quackenbush 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:338556 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
