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]
==^=======================================================
