AnsweredAssumed Answered

Need to include specail character in gel update to sql

Question asked by reugene on Mar 9, 2017
Latest reply on Mar 9, 2017 by reugene

Whenever there is a name change in my PSD object, I update the name of it's child object (COG) so they are always the same.  The update works except with special characters (like apostrophe).  Can someone please help me fix my code so that it wont fail when there is an apostrophe in the parent name?

 

update odf_ca_zc_cogs
    set name = '${psd_name}'
        where ODF_PARENT_ID = ${gel_objectInstanceId}

 

Thanks in advance for your help!

Rob

Outcomes