Are you using CFSTOREDPROC or CFQUERY? If you want to fire a stored proceedure (like an update proceedure), CFSTOREDPROC would be the preferred way. Also what version of CF are you using? CFSTOREDPROC is handy with SQL Server because it also lets you get multiple recordsets back from the DB with one call. But that is another subject all togethor... Cheers! ---------------------------------------------------------------------- Robin Greenhagen http://www.greensoft.com/ President GreenSoft Solutions, Inc. ---------------------------------------------------------------------- > -----Original Message----- > From: Ryan Hartwich [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 20, 2000 5:21 PM > To: Robin Greenhagen > Subject: [KCFusion] Triggers/Stored Procedures - MS SQL 6.5 > > > We have code within Cold Fusion which does updates to a SQL > Server database. > These updates execute triggers on different fields in the > database. Within > the triggers, stored procedures are called. When the updates > are done in > Cold Fusion, the trigger is started but the stored procedures > do not execute > properly and the update that kicked off the trigger does not complete > successfully. When the exact same update statement is done in > ISQL, the > trigger and the stored procedure execute properly. We have > also had some > success when different, less processing intensive stored > procedures are > called from the triggers. Are there settings within Cold > Fusion or within > SQL Server that will alleviate this issue? > > Ryan Hartwich > [EMAIL PROTECTED] > 913-642-1600x223 > > > > ______________________________________________________________________ > The KCFusion.org list and website is hosted by Humankind Systems, Inc. > List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org > Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] > To Subscribe.................... mailto:[EMAIL PROTECTED] > To Unsubscribe................ mailto:[EMAIL PROTECTED] > > ______________________________________________________________________ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives........ http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe.................... mailto:[EMAIL PROTECTED] To Unsubscribe................ mailto:[EMAIL PROTECTED]
