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:338545
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
