[ pl4stik @ 25.10.2011. 16:51 ] @
Code: 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 ali mi javlja Msg 102, Level 15, State 1, Procedure mailreminder, Line 10 Incorrect syntax near '+'. Help... |