# Comments in named queries?

**URL:** <https://forum.inductiveautomation.com/t/comments-in-named-queries/53709>\
**Category:** Ignition\
**Tags:** namedqueries, perspective, ignition81\
**Created:** [December 2, 2021, 11:15pm UTC](https://forum.inductiveautomation.com/t/comments-in-named-queries/53709 "2021-12-02T23:15:46Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [December 3, 2021, 12:18am UTC](https://forum.inductiveautomation.com/t/comments-in-named-queries/53709/2 "2021-12-03T00:18:54Z")

</div>

Comments are fine, it’s just that our parser is (currently) too dumb to distinguish a commented _parameter_ from a legitimate one, so:

```sql
SELECT * FROM TABLE WHERE 
A = :param
--AND B = :param2

```

_Should_ be fine, but is what currently throws an error, because the parser thinks it needs an additional value for `param2`.

---

_[View the full topic](https://forum.inductiveautomation.com/t/comments-in-named-queries/53709)._