Does Lucee support any single character wildcards in QoQ?

As title, asked on SO
http://stackoverflow.com/questions/41764840/does-lucee-support-any-single-character-wildcards-in-qoq
.

Thanks in advance for any assistance.

I think you want this:
http://hsqldb.org/doc/guide/dataaccess-chapt.html#N125D3

i.e.

LIKE ‘_abc’ – any 1 char then abc
LIKE ‘!_abc’ ESCAPE ‘!’ – actual underscore char then abcOn Fri, Jan 20, 2017 at 8:32 AM, Dave Merrill <@Dave_Merrill> wrote:

As title, asked on SO
http://stackoverflow.com/questions/41764840/does-lucee-support-any-single-character-wildcards-in-qoq
.

Thanks in advance for any assistance.


You received this message because you are subscribed to the Google Groups
“Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send an
email to lucee+unsubscribe@googlegroups.com.
To post to this group, send email to lucee@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/
msgid/lucee/bf749b07-dbcc-4a90-96d4-dcc63b064e1b%40googlegroups.com
https://groups.google.com/d/msgid/lucee/bf749b07-dbcc-4a90-96d4-dcc63b064e1b%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

https://luceeserver.atlassian.net/browse/LDEV-1165

Ping if anyone knows anything further about this.

Thanks.On Friday, January 20, 2017 at 10:37:59 AM UTC-5, Dave Merrill wrote:

Thanks for jumping in. Turns out that Lucee 5.1 crashes if you use NOT
LIKE and ESCAPE together:

Encountered “ESCAPE” at line […]. Was expecting one of: “AND” …
“CONNECT” …

That’s what my code does, so I didn’t think ESCAPE was supported at all.
Seems like a bug to me.

On Friday, January 20, 2017 at 8:42:24 AM UTC-5, Joseph Gooch wrote:

I think you want this:
http://hsqldb.org/doc/guide/dataaccess-chapt.html#N125D3

i.e.

LIKE ‘_abc’ – any 1 char then abc
LIKE ‘!_abc’ ESCAPE ‘!’ – actual underscore char then abc

On Fri, Jan 20, 2017 at 8:32 AM, Dave Merrill enig...@gmail.com wrote:

As title, asked on SO
http://stackoverflow.com/questions/41764840/does-lucee-support-any-single-character-wildcards-in-qoq
.

Thanks in advance for any assistance.


You received this message because you are subscribed to the Google
Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/bf749b07-dbcc-4a90-96d4-dcc63b064e1b%40googlegroups.com
https://groups.google.com/d/msgid/lucee/bf749b07-dbcc-4a90-96d4-dcc63b064e1b%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

Turns out that using WHERE NOT Name LIKE ‘test_’ ESCAPE ‘’, instead of Name
NOT LIKE ‘test_’ ESCAPE ‘’, works fine, in both ACF and Lucee.

Thanks to Leigh http://stackoverflow.com/users/104223/leigh on SO for
this.

DaveOn Friday, January 20, 2017 at 11:04:01 AM UTC-5, Dave Merrill wrote:

https://luceeserver.atlassian.net/browse/LDEV-1165

Ping if anyone knows anything further about this.

Thanks.

On Friday, January 20, 2017 at 10:37:59 AM UTC-5, Dave Merrill wrote:

Thanks for jumping in. Turns out that Lucee 5.1 crashes if you use NOT
LIKE and ESCAPE together:

Encountered “ESCAPE” at line […]. Was expecting one of: “AND” …
“CONNECT” …

That’s what my code does, so I didn’t think ESCAPE was supported at all.
Seems like a bug to me.

On Friday, January 20, 2017 at 8:42:24 AM UTC-5, Joseph Gooch wrote:

I think you want this:
http://hsqldb.org/doc/guide/dataaccess-chapt.html#N125D3

i.e.

LIKE ‘_abc’ – any 1 char then abc
LIKE ‘!_abc’ ESCAPE ‘!’ – actual underscore char then abc

On Fri, Jan 20, 2017 at 8:32 AM, Dave Merrill enig...@gmail.com wrote:

As title, asked on SO
http://stackoverflow.com/questions/41764840/does-lucee-support-any-single-character-wildcards-in-qoq
.

Thanks in advance for any assistance.


You received this message because you are subscribed to the Google
Groups “Lucee” group.
To unsubscribe from this group and stop receiving emails from it, send
an email to lucee+un...@googlegroups.com.
To post to this group, send email to lu...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/lucee/bf749b07-dbcc-4a90-96d4-dcc63b064e1b%40googlegroups.com
https://groups.google.com/d/msgid/lucee/bf749b07-dbcc-4a90-96d4-dcc63b064e1b%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.