Description Usage Arguments Details Value Examples
renderSql
Renders SQL code based on parameterized SQL and parameter values.
1 |
sql |
The parameterized SQL |
... |
Parameter values |
This function takes parameterized SQL and a list of parameter values and renders the SQL that can be send to the server. Parameterization syntax:
Parameters are indicated using a @ prefix, and are replaced with the actual values provided in the renderSql call.
Default values for parameters can be defined using curly and the DEFAULT keyword.
The if-then-else pattern is used to turn on or off blocks of SQL code.
A list containing the following elements:
The original parameterized SQL code
The rendered sql
1 2 3 4 5 6 7 8 9 10 11 12 13 | renderSql("SELECT * FROM @a;", a = "myTable")
renderSql("SELECT * FROM @a {@b}?{WHERE x = 1};", a = "myTable", b = "true")
renderSql("SELECT * FROM @a {@b == ''}?{WHERE x = 1}:{ORDER BY x};", a = "myTable", b = "true")
renderSql("SELECT * FROM @a {@b != ''}?{WHERE @b = 1};", a = "myTable", b = "y")
renderSql("SELECT * FROM @a {1 IN (@c)}?{WHERE @b = 1};",
a = "myTable",
b = "y",
c = c(1, 2, 3, 4))
renderSql("{DEFAULT @b = \"someField\"}SELECT * FROM @a {@b != ''}?{WHERE @b = 1};",
a = "myTable")
renderSql("SELECT * FROM @a {@a == 'myTable' & @b != 'x'}?{WHERE @b = 1};",
a = "myTable",
b = "y")
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.