Does Lucee support any single character wildcards in QoQ?

dev google-group-archive
1

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.

2

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.

3

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:
Chapter 5. Data Access and Change

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.

4

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:
Chapter 5. Data Access and Change

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.