Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The name attribute should match the parameter variable name and the value attribute will be used as the test data input when testing the SQL query.

...


...

Quotes Around Parameters

Do not put quotes around request parameters. It will cause the following error, indicating the parameter is not read.  Parameter index out of range (3 > number of parameters, which is 2).

Code Block
 select CASE 
          	WHEN '$postId' is null THEN (SELECT POST_ID as id from POST where POST_URL= $url)
            ELSE $postId END
          as 'id'


Info
The runtime engine ignore parameters that are put inside string quotes.