[firebird-support] Re: Help with trigger syntax

2011-11-01 Thread grip_2ls
Thank you all for your help and advice. N --- In firebird-support@yahoogroups.com, Mark Rotteveel mark@... wrote: On Tue, 01 Nov 2011 10:00:38 +1300, Helen Borrie helebor@... wrote: At 07:56 AM 1/11/2011, you wrote: On 31-10-2011 17:46, grip_2ls wrote: Hi Mark Thanks for the advise

[firebird-support] Re: Help with trigger syntax

2011-10-31 Thread grip_2ls
Mark For some reason I cannot get the pre/code html tags to work so I have put the code here: http://pastebin.com/p3kt7bud Line 19/25 is the second character of the smtp server. Thanks for pointing out my lack of security - I will change that now. Thanks N --- In

Re: [firebird-support] Re: Help with trigger syntax

2011-10-31 Thread Mark Rotteveel
On Mon, 31 Oct 2011 15:57:27 -, grip_2ls li...@2ls.com wrote: Mark For some reason I cannot get the pre/code html tags to work so I have put the code here: http://pastebin.com/p3kt7bud I am a bit rusty in my PSQL and trigger code, but as far as I know you can do SELECT without INTO

Re: [firebird-support] Re: Help with trigger syntax

2011-10-31 Thread Mark Rotteveel
On Mon, 31 Oct 2011 17:06:34 +0100, Mark Rotteveel m...@lawinegevaar.nl wrote: I am a bit rusty in my PSQL and trigger code, but as far as I know you can do SELECT without INTO like you are doing when calling that SendEmail function (or procedure?). Uhm, that should have been '.. you can't do

[firebird-support] Re: Help with trigger syntax

2011-10-31 Thread grip_2ls
Hi Mark Thanks for the advise but I don't think that is the issue. If you remove the second select statement it compiles and runs fine. N --- In firebird-support@yahoogroups.com, Mark Rotteveel mark@... wrote: On Mon, 31 Oct 2011 17:06:34 +0100, Mark Rotteveel mark@... wrote: I am a bit

RE: [firebird-support] Re: Help with trigger syntax - Email found in subject

2011-10-31 Thread Leyne, Sean
Thanks for the advise but I don't think that is the issue. If you remove the second select statement it compiles and runs fine. Actually, that is the issue. It is the 2nd SELECT which is the problem, so by removing it, you removed the problem. To invoke the SendMail UDF, you should

Re: [firebird-support] Re: Help with trigger syntax

2011-10-31 Thread Helen Borrie
At 07:56 AM 1/11/2011, you wrote: On 31-10-2011 17:46, grip_2ls wrote: Hi Mark Thanks for the advise but I don't think that is the issue. If you remove the second select statement it compiles and runs fine. That was exactly the issue I was pointing out. You are using SELECT without INTO to