Does Lucee support any single character wildcards in QoQ?

[Dave Merrill]

As title, asked on SO.

Thanks in advance for any assistance.

[Joseph Gooch]

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.

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 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.
For more options, visit https://groups.google.com/d/optout.

[Dave Merrill]

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.

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.

[Dave Merrill]

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

Ping if anyone knows anything further about this.

Thanks.

[Dave Merrill]

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 on SO for this.

Dave