I could do that, but I was hoping I wouldn't have to specify the
individual fields, and just pass the collection for parsing.
If I were to add any fields I would have to re-write the trigger which
is something I was trying to avoid.
On 13/09/11 09:53, Claudio Nanni wrote:
Hi,
Just quick r
Hi,
Just quick reading your email, forgive me if I'm mistaken
what about serializing using *concat(old.f1,'|||',old.f2,'|||',old.f3)
('|||' = any separator that works for you)*
and deserialize inside the function?
does this make any sense to you?
Cheers
Claudio
2011/9/13 Chris Tate-Davies
>
Thanks,
I kinda guessed that, but I'm not sure how to pass the OLD object to it
as MySQL cannot handle a rowset datatype.
Has anyone had any experience with this? Not sure where to start or how
to proceed.
Chris
On 13/09/11 07:40, Luis Motta Campos wrote:
On 8 Sep 2011, at 16:23, Chris T
On 8 Sep 2011, at 16:23, Chris Tate-Davies wrote:
> Hello. I want to know if there is a special way I can access all the data in
> the NEW/OLD data?
>
> I realise I can access it by referencing NEW.fieldname but I want to
> serialise the NEW object so I can save as a string. Is this possible or
Hello. I want to know if there is a special way I can access all the
data in the NEW/OLD data?
I realise I can access it by referencing NEW.fieldname but I want to
serialise the NEW object so I can save as a string. Is this possible or
do I need to write a function?
Thanks, Chris
*Chris T