# REGEX String Leakage in 7.9 Bindings

**URL:** <https://forum.inductiveautomation.com/t/regex-string-leakage-in-7-9-bindings/107416>\
**Category:** Ignition\
**Tags:** ignition79, vision\
**Created:** [June 16, 2025, 12:41pm UTC](https://forum.inductiveautomation.com/t/regex-string-leakage-in-7-9-bindings/107416 "2025-06-16T12:41:46Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jacob.leonard](https://avatars.discourse-cdn.com/v4/letter/j/da6949/32.png) [@jacob.leonard](https://forum.inductiveautomation.com/u/jacob.leonard)\
**Post date:** [June 16, 2025, 12:41pm UTC](https://forum.inductiveautomation.com/t/regex-string-leakage-in-7-9-bindings/107416/1 "2025-06-16T12:41:46Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/8/78c7bf743cae86c7f09790f78de957f6475e20b0.png)  
Using 7.9.21, and a oracle 12 SQL Database, it seems that using a REGEX like clause causes this error in a binding and not in the database query browser.

After some testing i find that it is the "{1,2}" part if the REGEX that is causing this issue.

As I am using 7.9.21, which is old, I ASSUME that this is fix in 8.1.

Looking over the string i need to test for, here isn't a good way to do this comparison without the {1,2}

Any ideas to make this work?

---

<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:** [June 16, 2025, 1:30pm UTC](https://forum.inductiveautomation.com/t/regex-string-leakage-in-7-9-bindings/107416/2 "2025-06-16T13:30:49Z")

</div>

Pass the regex string as a parameter in a named query or scripted "Prep" query.

---

<div class="post-metadata">

**Author:** ![jacob.leonard](https://avatars.discourse-cdn.com/v4/letter/j/da6949/32.png) [@jacob.leonard](https://forum.inductiveautomation.com/u/jacob.leonard)\
**Post date:** [June 16, 2025, 1:42pm UTC](https://forum.inductiveautomation.com/t/regex-string-leakage-in-7-9-bindings/107416/3 "2025-06-16T13:42:46Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/7/2763e35f82bea7be154d9a1f272a0ab1e2b77236.png)

I found a workaround for anyone who likes REGEX and it seems and it wont involve name querys

---

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [June 16, 2025, 2:01pm UTC](https://forum.inductiveautomation.com/t/regex-string-leakage-in-7-9-bindings/107416/4 "2025-06-16T14:01:22Z")

</div>

> [@jacob.leonard](#):
>
> and it wont involve name querys

You should prefer named queries.