| Subject | Re: [firebird-support] Re: Help with trigger syntax |
|---|---|
| Author | Mark Rotteveel |
| Post date | 2011-10-31T16:06:34Z |
On Mon, 31 Oct 2011 15:57:27 -0000, "grip_2ls" <lists@...> wrote:
do SELECT without INTO like you are doing when calling that SendEmail
function (or procedure?).
You probably just need to get rid of the SELECT .... FROM RDB$DATABASE
stuff around the SendEmail call, but maybe someone with more knowledge of
PSQL knows more.
> Markput
>
> For some reason I cannot get the pre/code html tags to work so I have
> the code here:I am a bit rusty in my PSQL and trigger code, but as far as I know you can
>
> http://pastebin.com/p3kt7bud
do SELECT without INTO like you are doing when calling that SendEmail
function (or procedure?).
You probably just need to get rid of the SELECT .... FROM RDB$DATABASE
stuff around the SendEmail call, but maybe someone with more knowledge of
PSQL knows more.
>Looks off to me ;)
> Line 19/25 is the second character of the smtp server.