List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:September 13 2011 8:53am
Subject:Re: Triggers - Accessing all NEW data
View as plain text  
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 <chris.tatedavies@stripped>

> 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 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 do I
>>> need to write a function?
>>>
>>
>> Hi,
>>
>> You'll have to write your own function for that.
>>
>> Cheers
>> --
>> Luis Motta Campos
>> is a DBA, Foodie, and Photographer
>>
>>
> --
>
> *Chris Tate-Davies*
>
> *Software Development*
> Inflight Productions Ltd
> Telephone: 01295 269 680
> 15 Stukeley Street | London | WC2B 5LT
>
> *Email:*chris.tatedavies@**inflightproductions.com<chris.tatedavies@stripped><mailto:
>
> chris.tatedavies@**inflightproductions.com<chris.tatedavies@stripped>
> >
> *Web:*www.inflightproductions.**com <http://www.inflightproductions.com> <
> http://www.**inflightproductions.com/<http://www.inflightproductions.com/>
> >
>
>
>
>
>
> -----------------------------
>
>
> Registered Office: 15 Stukeley Street, London WC2B 5LT, England.
> Registered in England number 1421223
>
> This message is for the designated recipient only and may contain
> privileged, proprietary, or otherwise private information. If you have
> received it in error, please notify the sender immediately and delete the
> original. Any other use of the email by you is prohibited. Please note that
> the information provided in this e-mail is in any case not legally binding;
> all committing statements require legally binding signatures.
>
>
> http://www.**inflightproductions.com <http://www.inflightproductions.com>
>
>


-- 
Claudio

Thread
Triggers - Accessing all NEW dataChris Tate-Davies8 Sep
  • Re: Triggers - Accessing all NEW dataLuis Motta Campos13 Sep
    • Re: Triggers - Accessing all NEW dataChris Tate-Davies13 Sep
      • Re: Triggers - Accessing all NEW dataClaudio Nanni13 Sep
        • Re: Triggers - Accessing all NEW dataChris Tate-Davies13 Sep