Customizing ProductCart - SQL Trigger to update a Table in Different DB

Print Page | Close Window

SQL Trigger to update a Table in Different DB

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Customizing ProductCart
Forum Description: Exchange messages with other users that are customizing ProductCart.
URL: https://forum.productcart.com/forum_posts.asp?TID=5548
Printed Date: 26-June-2024 at 5:23am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: SQL Trigger to update a Table in Different DB

Posted By: MichaelShiffman
Subject: SQL Trigger to update a Table in Different DB
Date Posted: 25-March-2013 at 4:32pm

I need to setup an SQL trigger when a product is purchase to insert a record in a table in another database on the same SQL server.

I also need to pass a variable from the order (Transaction code) as part of the downloadable URL.

If you can help with this I am happy to pay for your time.

Thanks,

Michael Shiffman
310-445-2160

-------------
Michael Shiffman
The Insight Center
http://insightcenter.org