|
|
Home /
Groups /
ColdFusion Talk (CF-Talk)
Database triggers stopped working in ColdFusion 8
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!
|
Mailing Lists
|
Latest Fusion Authority Articles
|
||||||