Igal Sapir

Recent Blog Comments By Igal Sapir

• CFQueryParam "Fails Silently" With Empty Lists And IN Clauses In Lucee 5.2.9.40

  Posted on Oct 13, 2019 at 12:05 AM

  I've looked into this issue today. The discrepancy between Lucee and ACF is that Lucee passes NULL for the empty list's value while ACF passes an empty string. In SQL NULL never matches anything, not even other NULLs, so both IN (NULL) and NOT IN (NULL) return no results, while in... read more »

• CFQueryParam "Fails Silently" With Empty Lists And IN Clauses In Lucee 5.2.9.40

  Posted on Oct 8, 2019 at 12:58 PM

  @Ben, No pressure at all. We prioritize and work on tickets on a regular basis. Some of the factors we take into account include: How many users are affected by this issue? How difficult is it to solve? Sometimes it's a matter of bringing a specific ticket to our attention. I wi... read more »

• CFQueryParam "Fails Silently" With Empty Lists And IN Clauses In Lucee 5.2.9.40

  Posted on Oct 8, 2019 at 11:51 AM

  At the very least we should throw a better error message, but we will review the compatibility issue and try to find the best way to resolve this. And yes, Semantic Versioning is both Fun and Important ;)... read more »

• CFQueryParam "Fails Silently" With Empty Lists And IN Clauses In Lucee 5.2.9.40

  Posted on Oct 8, 2019 at 11:44 AM

  This shouldn't be hard to fix. I'm a bit swamped ATM but will look into it soon. Igal... read more »

• Sort Only Works With directoryList() When ListInfo Is Query In Lucee 5.2.9.31

  Posted on Oct 8, 2019 at 11:43 AM

  That's great to hear! I, too, love the Labmdas. I actually posted about that recently on LinkedIn with a screenshot from my recent talk at ApacheCon: I Love Lucee!... read more »

• Sort Only Works With directoryList() When ListInfo Is Query In Lucee 5.2.9.31

  Posted on Oct 7, 2019 at 1:25 PM

  @Ben, That's great to hear! Feel free to reach out if I can be of help, though it's best to contact me directly or at least in the Lucee forum so that I'll see it in a timely manner. For some reason I got a notification of Sabrina's comment from today but not for yours from Feb 20th. B... read more »

• Sort Only Works With directoryList() When ListInfo Is Query In Lucee 5.2.9.31

  Posted on Oct 7, 2019 at 1:22 PM

  @Sabrina, Update to the latest 5.3.2.x or at least to Lucee 5.3.2.41 which resolves this issue. Best, Igal... read more »

• Sort Only Works With directoryList() When ListInfo Is Query In Lucee 5.2.9.31

  Posted on Feb 8, 2019 at 11:38 PM

  Thank you for your kind words, Ben. In most cases we consider incompatibility with ACF to be a bug. This was more of an observation on cfdocs.org, rather than a documented behavior. Anyway, I am happy to say that the issue is resolved for Lucee 5.3.2.41 https://luceeserver.atlassian.net/b... read more »

• Sort Only Works With directoryList() When ListInfo Is Query In Lucee 5.2.9.31

  Posted on Feb 5, 2019 at 12:59 AM

  Ben, Another way to document it for your future self (and increase the chances of it being fixed altogether), is to open at ticket in the JIRA ;) I went ahead and opened one for this issue: https://luceeserver.atlassian.net/browse/LDEV-2152 I will look into it soon. Best, Igal... read more »