Hi,
I am using the &sql () tag to retrieve the value from the Cache DB.
below is the piece of code i am using:
script language="cache" method="retrieveDetail" arguments="pVariable" returntype="%String"
&sql( select columnA,
into :tempVariable1
from TABLE
where COLUMNC = pVariable
quit tempVariable1
i have to return the ColumnA value back to the calling procedure.
can i know how it can be done ? since i am getting an javascript error.