How to address properties in MySQL query

Hi there,

I hope someone could help, I have the following scenario:

I am using DataSource "Data Connection" to connect to our database.

I have a global property on TestSuite level named "propEntityID" w/ value 20 for example.

Now I have the following SQL select statement:

SELECT * FROM databasetable WHERE entity_id = ${#TestSuite#propEntityID}

When I run this I get a Soap error: "Can't get the Connection for specified properties; com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column '$' in 'where clause'" as well as a Java Error "Unexpected token "{" at line 3, pos 50".

How do I correctly address the TestSuite property and how do I mask/escape the special characters such as "$" and "{" respectively?

Help appreciated.

Kind regards