[es] - Kako da dodam parametar u sp

pl4stik
Senior .NET programmer/Consultant
oDesk
NI na nebu NI na zemlji

Član broj: 173596
Poruke: 715
*.dynamic.isp.telekom.rs.

Sajt: xx-auth.com.azhar.arvixe...

+31 Profil

Kako da dodam parametar u sp

^{25.10.2011. u 16:51 - pre 152 meseci}

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...

To sto nekoliko miliona ljudi tvrdi da nisi u pravu ne znaci da stvarno nisi - Frank Zappa

https://youtu.be/DLe358DPGXU

Odgovor na temu

Koce
DBA
Serbia, Belgrade

Član broj: 59217
Poruke: 144
82.214.127.*

+1 Profil

Re: Kako da dodam parametar u sp

^{01.11.2011. u 14:45 - pre 151 meseci}

sve ovo stavi u promjenjivu pa probaj
tj:
Declare @Str as varchar(500)= 'http://localhost:52055/RadarCS...dMail.asmx/InsertMail?incomin=' + ChartType.Type;
i dole naravno zamjeni string sa promjenjivom.

Odgovor na temu