# Comments panel

**URL:** <https://forum.inductiveautomation.com/t/comments-panel/7903>\
**Category:** Ignition\
**Created:** [January 26, 2014, 11:05pm UTC](https://forum.inductiveautomation.com/t/comments-panel/7903 "2014-01-26T23:05:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![howarddpsg](https://avatars.discourse-cdn.com/v4/letter/h/ecc23a/32.png) [@howarddpsg](https://forum.inductiveautomation.com/u/howarddpsg)\
**Post date:** [January 26, 2014, 11:05pm UTC](https://forum.inductiveautomation.com/t/comments-panel/7903/1 "2014-01-26T23:05:46Z")

</div>

ok I am trying to use last name in the comments panel as the usernames are coded and wouldn’t help know who wrote the comment. here is what I am trying to use however I get an error referring to the root container.  
used an expression to write this.

"INSERT INTO comments\_panel "+  
"(NoteText, username, Timestamp, Stick) "+  
"Values "+  
“(?, {Root Container.lastname}, Current\_TimeStamp, ?)”

very simple however I am now expanding and need the lastname instead of ‘%s’

Thanks

---

<div class="post-metadata">

**Author:** ![howarddpsg](https://avatars.discourse-cdn.com/v4/letter/h/ecc23a/32.png) [@howarddpsg](https://forum.inductiveautomation.com/u/howarddpsg)\
**Post date:** [January 27, 2014, 12:15am UTC](https://forum.inductiveautomation.com/t/comments-panel/7903/2 "2014-01-27T00:15:38Z")

</div>

here is the error I get.

GatewayException: SQL error for “INSERT INTO comments\_panel (NoteText, username, Timestamp, Stick) Values (?, {Root Container.Comments Panel.firstname}, Current\_TimeStamp, ?)”: ‘Root’ is not a recognized ODBC scalar function option.  
caused by SQLServerException: ‘Root’ is not a recognized ODBC scalar function option.

Ignition v7.6.4 (b2013112117)  
Java: Oracle Corporation 1.7.0\_51

---

<div class="post-metadata">

**Author:** ![howarddpsg](https://avatars.discourse-cdn.com/v4/letter/h/ecc23a/32.png) [@howarddpsg](https://forum.inductiveautomation.com/u/howarddpsg)\
**Post date:** [January 27, 2014, 1:24am UTC](https://forum.inductiveautomation.com/t/comments-panel/7903/3 "2014-01-27T01:24:49Z")

</div>

figured out myself.

"INSERT INTO comments\_panel "+  
"(NoteText, username, Timestamp, Stick) "+  
"Values "+  
“(?, '”+  
{Root Container.Comments Panel.firstname}+  
“’, Current\_TimeStamp, ?)”