Baza je MS SQL
Imam triger na koji se izvrsi sp koja salje web service call
Kôd:
USE RADAR
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'mailreminder' AND type = 'TR')
DROP TRIGGER mailreminder
GO
CREATE TRIGGER mailreminder
ON ChartType
FOR INSERT
AS
Declare @Object as Int;
Declare @ResponseText as Varchar(8000);
Exec sp_OACreate 'MSXML2.XMLHTTP', @Object OUT;
Exec sp_OAMethod @Object, 'open', NULL, 'get',
'http://localhost:52055/RadarCS...l.asmx/InsertMail?incomin=MSFT' ,
'false'
Exec sp_OAMethod @Object, 'send'
Exec sp_OAMethod @Object, 'responseText', @ResponseText OUTPUT
Select @ResponseText
Exec sp_OADestroy @Object
GO
U trinestom redu umesto hard coded MSFT treba da posaljem to sto mi triger vrati. Znaci 13ti red bi izgledao kao:
'http://localhost:52055/RadarCS...dMail.asmx/InsertMail?incomin=' + ChartType.Type ili INSERTED.Type
ali mi javlja
Msg 102, Level 15, State 1, Procedure mailreminder, Line 10
Incorrect syntax near '+'.
Nisam neki SQLash aj ako neko zna nek napishe