How to escape templates so script blocks and date literals are not stripped when calling evaluateTemplate or doQuery?

Question

When I use a template with evaluateTemplate or a ODBC date literal with doQuery the function bodies and date literals are stripped out.  How can I embed curly braces with content without it being stripped out of the result?

Answer 1

Javascript Function Block Example:

var template = "<script>\n" +

" function updateSettings() {\n" +

"   alert('test');\n" + 

" }\n" +

"</script>";

 

qie.evaluateTemplate(template, parameters);

 

Bad Result:

<script>

function updateSettings()

</script>

 

Solution - Use numeric character references:

var template = "<script>\n" +

" function updateSettings() &#123;\n" +

" alert('test');\n" + 

" &#125;\n" +

"</script>";

 

qie.evaluateTemplate(template, parameters);

 

Good Result:

<script>

function updateSettings() {

  alert('test');

}  

</script>

Answer 2

SQL ODBC Date Literal Example:

qie.doQuery(dbName, "select * from person where birth = {d '2000-09-09'}");

 

Bad Result:

select * from person where birth =

 

Solution - Use numeric character references:

qie.doQuery(dbName, "select * from person where birth = &#123;d '2000-09-09'&#125;");

 

Good Result:

select * from person where birth = {d '2000-09-09'}

 

Alternatively use other supported date or date literal syntax as per database vendor.  See these Date Literal references:

SQL Server

Oracle

MySql

Answer 3

Also see:

How to escape curly braces in QIE?