I don't have a specific SQL script for this but here is some sample code on using a COM object in SQL:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_14_2ktw.asp HTH, Howie ----- Original Message ----- From: "webguy" <[EMAIL PROTECTED]> To: "inFusion Support List" <[EMAIL PROTECTED]> Sent: Friday, October 24, 2003 7:45 AM Subject: [iMS] COM / SQL Server > > Does anyone have a example of using the COM object from SQL Server. > > Say I have a trigger like below (I know its not exactly right) > > SELECT EmailAddress,FullName > FROM Users > WHERE ProductID =( > SELECT ProductID > FROM INSERTED > ) > > SELECT @Product_Price = Price, > @Product_Desc = Description > FROM Products > WHERE ProductID = ( > SELECT ProductID > FROM INSERTED > ) > > How do I send the Price and Desciption to the users ? > I'll start searching the archives too. > > Thanks Justin ==^======================================================= This list server is Powered by iMS "The Swiss Army Knife of Mail Servers" -------------------------------------------------------------------------------------- This list is provided as a free service. Although we will try to address issues in a timely manner, support via this list is not guaranteed. If you require expedited support then a support contract is required. Support may be purchased from http://www.coolfusion.com/commerce. Details regarding support options may be reviewed at: http://www.coolfusion.com/SupportOptions.cfm -------------------------------------------------------------------------------------- To leave this list please complete the form at http://www.coolfusion.com/Support/ Need an iMS Developer license? Sign up for a free license here: http://www.coolfusion.com/Developers/ List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/ Note: You are subscribed as [EMAIL PROTECTED] ==^=======================================================
