Home of the ColdFusion Community
|
Mailing Lists
|
Home /
Groups /
ColdFusion Talk (CF-Talk)
Database triggers stopped working in ColdFusion 8
Author: Richard Davies
Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:57342#311280
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!
|
February 11, 2012
|
Latest Fusion Authority Articles
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
