Disclaimer: I have not read every single response on this thread
> And the result is a big fat "TMP is undefined" exception
> being thrown.
Wrap the two statements in SET NOCOUNT ON / OFF
Though not all identical to your case, there were a _lot_ of blog entries on
similar issues with inserts, the "result" attribute and scope_identity(). A
search on CF8 / cfquery result attribute / scope_identity() should turn up a
bunch of results.
-Leigh
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:338606
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
