Errors defining the destination for SQLAssembler inside data-management-config.xml

[Former Community Member]

Hello,



I am following the LCDS ES sample at
http://localhost:8700/samples/#sqlassembler

for defining a destination inside data-management-config.xml,
there you can define SQL

statements that can be referred to from MXML



I am having the following error:



'Error in SQL for 'fill' in destination 'sql-product'.
Matching pair of # tokens not found'



And the statement it is referring to, from within the
data-management-config.xml file is:



<name>getAllForServer</name>

<sql>SELECT * FROM MYTABLE

WHERE SERVER_ID = #SERVER_ID#

</sql>



I do not understand the # syntax, and how can it be used
universally? for example, setting the value of LIMIT, or variables
in WHERE statements