Reply to thread

Message

<blockquote data-quote="pnyberg" data-source="post: 490030" data-attributes="member: 24255">Came to think about triggers in MS SQL... I just added a trigger to my schedule table which enables me to set &quot;recommendedcard&quot; to what I want. Used this simple SQL statement:USE [MpTvDb]GO/****** Object:&nbsp; Trigger [dbo].[recommendedcard]&nbsp; &nbsp; Script Date: 07/26/2009 22:27:35 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- =============================================-- Author:&nbsp; &nbsp; &nbsp; &nbsp; Patrik-- Create date: 2009-07-26-- Description:&nbsp; &nbsp; Trigger to update recommended.card-- =============================================ALTER TRIGGER [dbo].[recommendedcard]&nbsp;&nbsp; ON&nbsp; [dbo].[Schedule] &nbsp;&nbsp; AFTER INSERT,UPDATEAS BEGIN&nbsp; &nbsp; -- SET NOCOUNT ON added to prevent extra result sets from&nbsp; &nbsp; -- interfering with SELECT statements.&nbsp; &nbsp; SET NOCOUNT ON;&nbsp; &nbsp; -- Insert statements for trigger here&nbsp; &nbsp; Update dbo.schedule set recommendedcard=2ENDI'm not sure if MySQL have triggers? Otherwise this should be fairly simple for the devs to incorporate in MP...?You need to add a setting in the configuration program of the tvservice where you can set your recommendedcard and then create/alter the trigger?Just a thought. But in the meantime this works for me.Keep up the good work devs!</blockquote>

[QUOTE="pnyberg, post: 490030, member: 24255"] Came to think about triggers in MS SQL... I just added a trigger to my schedule table which enables me to set "recommendedcard" to what I want. Used this simple SQL statement: [B]USE [MpTvDb] GO /****** Object: Trigger [dbo].[recommendedcard] Script Date: 07/26/2009 22:27:35 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: Patrik -- Create date: 2009-07-26 -- Description: Trigger to update recommended.card -- ============================================= ALTER TRIGGER [dbo].[recommendedcard] ON [dbo].[Schedule] AFTER INSERT,UPDATE AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for trigger here Update dbo.schedule set recommendedcard=2 END[/B] I'm not sure if MySQL have triggers? Otherwise this should be fairly simple for the devs to incorporate in MP...? You need to add a setting in the configuration program of the tvservice where you can set your recommendedcard and then create/alter the trigger? Just a thought. But in the meantime this works for me. Keep up the good work devs! [/QUOTE]

Verification