On Mon, 31 Oct 2011 15:57:27 -, "grip_2ls" 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 like you
On Mon, 31 Oct 2011 17:06:34 +0100, Mark Rotteveel
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 SELECT without INT
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 call SendMail. That doesn't wor
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
>witho
On Tue, 01 Nov 2011 10:00:38 +1300, Helen Borrie
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 but I don't think that is the issue. If you
>>> remove the second select statement it compiles and runs fine.
>>
>>That was e
> 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 defi