# Basic SQL Query Report. Column Name value problem

**URL:** <https://forum.inductiveautomation.com/t/basic-sql-query-report-column-name-value-problem/41738>\
**Category:** Ignition\
**Created:** [December 22, 2020, 9:30pm UTC](https://forum.inductiveautomation.com/t/basic-sql-query-report-column-name-value-problem/41738 "2020-12-22T21:30:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![wking](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/wking/32/21823_2.png) [@wking](https://forum.inductiveautomation.com/u/wking)\
**Post date:** [December 22, 2020, 9:30pm UTC](https://forum.inductiveautomation.com/t/basic-sql-query-report-column-name-value-problem/41738/1 "2020-12-22T21:30:00Z")

</div>

I’ve tried with && and backticks. What the heck?

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/1/110a81f1203bd42938d6a277652bb5582b5d36b4.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/3/a310a78a9efa6cd046b2a7064b1bc9043e951877.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/1/412e8bb65c4c3722a7b349a4b02d42f21d8aa8c8.png)

–

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/4/d424917e9ef10630a50278d1211356e563711faf.png)

–

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/f/9f7f4be0758a2fe9373fa6edaaf660141867f486.png)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [December 22, 2020, 9:44pm UTC](https://forum.inductiveautomation.com/t/basic-sql-query-report-column-name-value-problem/41738/2 "2020-12-22T21:44:30Z")

</div>

Put question marks into your SQL instead of the curly braces. You will get expression boxes for them below the SQL. Connect your parameters there.

Curly braces are string substitutions. You want JDBC parameters to avoid quoting problems.
