House of Fusion
Home of the ColdFusion Community

Search cf-talk

December 02, 2008

<<   <   Today   >   >>
Su Mo Tu We Th Fr Sa
   1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 31       

Search over 2,500 ColdFusion resources here  >>>      
Home /  Groups /  ColdFusion Talk (CF-Talk)

Database triggers stopped working in ColdFusion 8

  << Previous Post |  RSS |  Sort Oldest First |  Sort Latest First |  Subscribe to this Group Next >> 
Top  |   Reply  |   Original Post  |   RSS Feed  |   Subscribe to this Group
Author:
Richard Davies
08/19/2008 01:44 PM

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!


<< Previous Thread Today's Threads Next Thread >>

Mailing Lists