Re: MS SQL Triggers and Coldfusion 8

2007-10-04 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
Message From: [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com 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

MS SQL Triggers and Coldfusion 8

2007-10-03 Thread [EMAIL PROTECTED] [EMAIL PROTECTED]
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

Re: MS SQL Triggers and Coldfusion 8

2007-10-03 Thread Ben Densmore
;databaseName=awayx;AlwaysReportTriggerResults=true Ben - Original Message From: [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Wednesday, October 3, 2007 3:48:18 PM Subject: MS SQL Triggers and Coldfusion 8 Hi all. We're in the process