AnsweredAssumed Answered

sql query variables?

Question asked by kamal1234 on May 13, 2016
Latest reply on May 27, 2016 by kamal1234

Dear Community Members,

 

I am trying to use ExecuteSQL statement but I am not be able to pass variables to the query.

 

I have seen may similar post for passing variables in query but I found them very advance and beyond my  understanding.

 

Please can someone help me how to concatenate following so that It picks up the values. At present, it is printing as it is.

 

update CPD_COMPWORKSDETAILS set DESCRIPTION="&PL_Competition::Description&", TITLE="&PL_Competition::Title&", AUTHOR="&PL_Competition::Author&", PUBLISHER="&PL_Competition::Publisher&", PRICE="&PL_Competition::Price&"  where CWID="&PL_Competition::CWID&"

 

Thank you,

Kamal.

Outcomes