0 Replies Latest reply on Oct 5, 2007 3:58 AM by

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

      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