Ability to use parameters in the midst of a text pull.

Question

Ability to use parameters in the midst of a text pull.

mwilday opened this issue 4 years ago · 3 comments

We'd like to be able to enter a parameter in the midst of SQL statement but are having difficulty doing it.

AND prefix_category_path = '/ :parameter/' but the query keeps failing. Is this possible? Am I just not sure how to do it?

Answer 1 · 2020-10-31T07:39:50.000Z

Parameter values are not just added to the query using string search and replace. They need to take the place of a single value in the SQL. So, to add them in the middle of a string, you need to use concatenation:

AND prefix_category_path = CONCAT('/', :parameter, '/')

Answer 2 · 2020-12-18T21:08:50.000Z

This is not a bug. Closing.

Answer 3 · 2020-12-18T21:46:47.000Z

Parameter values are not just added to the query using string search and replace. They need to take the place of a single value in the SQL. So, to add them in the middle of a string, you need to use concatenation:

AND prefix_category_path = CONCAT('/', :parameter, '/')

Thank you, this is incredibly helpful!!!