After upgrading to CF8, my insert triggers are no longer returning results to
cfquery. I've tried the solution listed at http://www.adobe.com/go/kb402302,
but my insert trigger still isn't returning any results to cfquery. This worked
fine (and still does) with CF7, but doesn't work on our new ColdFusion 8
server. We're running CF 8.0.1.195765 and MS SQL Server 2005.
The insert trigger is SELECT * FROM inserted
Our CFML query code is:
<cfquery name="addContent" datasource="cms" result="qresult">
INSERT INTO content
(content_name, content_type, content_parent_id, owner_contact_id,
summary_text, allow_comments)
VALUES
('image.jpg', 'B', 0, 29367, '', 0)
</cfquery>
<cfdump var="#qresult#">
<cfdump var="#addContent#">
The qresult variable is set correctly, but addContent is undefined after the
query executes (it should contain the record returned by the database trigger).
Does anyone have any ideas why AlwaysReportTriggerResults=true isn't working or
how I can get it to work? Thanks in advance for any help!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311280
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
