It is quite easy to use a parameter as a table name or in any other portion of a SQL statement, e.g. IN ( ... ) syntax.
Instead of using the ## denotation, use $$. For example:
SELECT * FROM $myValue$ WHERE AGE=#myAge#
Be sure to indicate 'remapResults="true"' in your definition. Using the $$ syntax instead of ## modifies the actual SQL statement, before parameters are applied.
| Be Careful The $$ syntax should be used with caution because of it's obvious potential for SQL injection attacks. |
