Hey Jim, that issue was fixed with the latest hotfix. http://kb.adobe.com/selfservice/viewContent.do?externalId=kb402466&sliceId=1
It's not listed in the notes, but I was the one who reported the bug and received an email back stating it was an official bug and that it would be fixed in the first hotfix. There is also a workaround to add the argument: AlwaysReportTriggerResults=true to your neo-datasource.xml file for that particular datasource. Or you can select "Other" as the driver type and enter in the jdbc driver manually as below: jdbc:macromedia:sqlserver://dbdev01:1433;databaseName=awayx;AlwaysReportTriggerResults=true Ben ----- Original Message ---- From: "[EMAIL PROTECTED] [EMAIL PROTECTED]" <[EMAIL PROTECTED]> To: CF-Talk <[email protected]> Sent: Wednesday, October 3, 2007 3:48:18 PM Subject: MS SQL Triggers and Coldfusion 8 Hi all. We're in the process of switching over from CF7 to CF8. We have a query that updates a row in a MS SQL database, which then causes a trigger to return a date value to Coldfusion. It worked in 7 but it doesn't seem to be working in 8. Coldfusion 8 is telling me that the query is undefined while that is not the case with the same query in Coldfusion 7. I searched the docs and release notes and the web, and the only clue I can find are the last few comments under this Ben Forta blog post: http://www.forta.com/blog/index.cfm/2007/7/6/ColdFusion-8-Can-Return-Identity-Values It seems that other people are having the same problem. So does anyone know if MS SQL triggers that return values officially don't work with Coldfusion 8? Thanks, Jim Sullivan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290104 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
